ttOptGetOrder

Description

Returns a single-row result set containing the join order for the current transaction. This result set can be retrieved using the ODBC SQLFetch function or the JDBC ResultSet.getXXX method, just like the result of a SQL SELECT statement. Join orders are described under the ttOptSetOrder built-in procedure.

Required privilege

This procedure requires no privilege.

Syntax

ttOptGetOrder( )

Parameters

ttOptGetOrder has no parameters.

Result set

ttOptGetOrder returns the result set:

Column	Type	Description
`joinOrder`	TT_VARCHAR(1024) NOT NULL	Optimizer join order for the current transaction.

Examples

CALL ttOptGetOrder;