Controls how the query optimizer adds in the semijoin predicates for push-down joins selected by the join optimizer.
ON, OFF
ON
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.
If ON, this option allows the insertion of semijoin predicates in projection-savings order.
