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 X 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 X 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: 04/03/2024