showjoinorder

Syntax

showjoinorder {0 | 1}

Description

Enables or disables the storing of join orders. It is enabled by default.

0 - Disables the storing of join orders

1 - Enables the storing of join orders.

Call the ttoptshowjoinorder built-in procedure explicitly to display the join order after SELECT, UPDATE, DELETE or MERGE SQL statements.

The showjoinorder command must be executed at the beginning of every transaction that you want to see join order information for. As soon as a commit or rollback occurs showjoinorder is automatically disabled.

Examples

Command> showjoinorder;