setjoinorder

Syntax

setjoinorder tblNames [...]

Description

Specifies the join order for the optimizer. AutoCommit must be off. unsetjoinorder clears the join order advice to the optimizer.

The join order is specified as a list of tables and table aliases. Use it to influence the query plan.

Examples

Command> Select * from TBL1 T1, TBL2 T2, TBL3 T3 where …..;
Command> Setjoinorder T2 T1 T3;

Showjoinorder reveals the most recent set value. See showjoinorder.