SET FLSQL or SET NOFLSQL overrides the setting of the DBMS configuration parameter opf_flsql in CBF. The default is ON, which means the optimizer attempts to flatten more correlated subqueries than previously. Use this parameter only if a flattened query (which was previously not flattened) is seen to degrade performance.