ttOptGetOrder

This procedure 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.

Related Views

This procedure has this related view.

SYS.V$OPT_ORDER

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.

Example

CALL ttOptGetOrder ();