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 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: 07/21/2025