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.