![RAND function results changed [CR 397838]](arrow-left.gif){kind=icon}
![Database options for push-down join optimizer tables [CR 368261]](arrow-right.gif){kind=icon}
The ENABLE_ORDERED_PUSHDOWN_INSERTION option was added for ESD #5. This option controls how the query optimizer adds in the semijoin predicates for push-down joins selected by the join optimizer.
ON, OFF
OFF
Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
Change this option only if Sybase Support instructs you to do so.
If OFF (the default), this option reverts the optimizer to the behavior seen in Sybase IQ 12.6 GA.
If ON, this option allows the insertion of semijoin predicates in projection-savings order.
