ttOptShowJoinOrder
SELECT
, UPDATE
,
DELETE
, and INSERT SELECT
) in the current
transaction. For a join order to be collected, use ttOptSetFlag
('ShowJoinOrder', 1)
or set the ttIsql
ShowJoinOrder
command to ON
(1) first in the same
transaction. AUTOCOMMIT
must be off when using either of these commands.
The join order is represented by the order of the table names.
Required Privilege
This procedure requires no privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic.
TimesTen Scaleout applications can call this built-in procedure.
In TimesTen Scaleout, this procedure runs locally on the element from which it is called.
Syntax
ttOptShowJoinOrder()
Parameters
ttOptShowJoinOrder
has no parameters.
Result Set
ttOptShowJoinOrder
returns the result:
Column | Type | Description |
---|---|---|
|
|
Table names, including owner name quantifiers and correlation name for each table if specified. Table names are returned in parentheses. Using a synonym to specify a table name is not supported. |
Examples
Command> AUTOCOMMIT 0; CALL ttOptSetFlag ('ShowJoinOrder', 1); PREPARE SELECT * FROM t1; CALL ttOptShowJoinOrder(); ( T1 )
Notes
-
You must call ttOptSetFlag
('ShowJoinOrder', 1)
or set the ttIsqlShowJoinOrder
command toON
(1
) before using this procedure. -
This procedure works within one transaction and is not persistent across transactions.