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.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

This procedure is supported in TimesTen Scaleout.

This procedure returns a row for the element from which it was called. To see information about other elements, query the SYS.GV$OPT_ORDER system table.

Related Views

This procedure has these related views.

SYS.GV$OPT_ORDER

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 ();