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, Ingres performs query flattening. (The ANSI entry SQL-92 standard specifies that query flattening is not performed.)
SET NOFLATTEN disables query flattening.
Last modified date: 01/30/2023