SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > [NO]FLATTEN
Was this helpful?
[NO]FLATTEN
SET FLATTEN specifies that query flattening be used to optimize queries, including queries involving aggregate subselects or singleton subselects.
By default, Actian X performs query flattening. (The ANSI entry SQL-92 standard specifies that query flattening is not performed.)
SET NOFLATTEN disables query flattening.
Last modified date: 11/09/2022