SQL Reference Guide > SQL Reference Guide > J. Settings for Strict ANSI Compliance > ISO_ENTRY_SQL-92 Parameter > Query Flattening
Was this helpful?
Query Flattening
The ANSI Entry SQL-92 standard specifies that query flattening is not performed. By default, Actian Ingres uses query flattening to improve the performance of queries.
ANSI/ISO Entry SQL-92
No Flattening:
dbmsinfo('flatten_singleton') returns N
dbmsinfo('flatten_aggregate') returns N
Actian Ingres Default
Flattening used to optimize queries, including queries involving aggregate subselects or singleton subselects:
dbmsinfo('flatten_singleton') returns Y
dbmsinfo('flatten_aggregate') returns Y
Last modified date: 07/21/2025