![FLOAT_AS_DOUBLE option [TSQL]](arrow-right.gif){kind=icon}
Enables the transformation of some simple correlated EXISTS and NOT EXISTS subqueries into equivalent join-based queries.
ON, OFF
Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
OFF
The option FLATTEN_SUBQUERIES enables the transformation of some simple correlated EXISTS and NOT EXISTS subqueries into equivalent join-based queries. In most cases in which the optimizer can apply this transformation, the query runs faster with the transformation than without the transformation applied. There are some exceptions to this performance improvement and some queries may run more slowly, so be sure that use of this option is appropriate for your environment.
