![STRING_RTRUNCATION option [TSQL]](arrow-left.gif){kind=icon}
Controls the placement of correlated subquery predicate operators within a query plan.
-1 to 1
Can be set for any scope, any user, takes immediate effect.
0
For correlated subquery operators within a query, the IQ optimizer may have a choice of several different valid locations within that query’s plan. This option allows you to override the optimizer’s cost-based decision when choosing the placement location. It does not override internal rules that determine whether a location is valid, and in some queries, there maybe only one valid choice. If you set this option to a non-zero value, it affects every correlated subquery predicate in a query; it cannot be used to selectively modify the placement of one subquery out of several in a query.
This option is normally used for internal testing, and only experienced DBAs should use it. The following table describes the valid values for this option and their actions.
Value |
Action |
|---|---|
0 |
Let the optimizer choose. |
1 |
Prefer a location high in the query plan, thereby delaying the execution of the subquery to as late as possible within the query. |
-1 |
Prefer a location as low as possible in the query plan, thereby placing the execution of the subquery as early as possible within the query. |
The default setting of this option is almost always appropriate. Occasionally, Sybase Technical Support may ask you to change this value.
