SUBQUERY_FLATTENING_PREFERENCE allowed values [CR 622967]

The actions of the allowed values for the SUBQUERY_FLATTENING_PREFERENCE database option in Chapter 2, “Database Options” are shown here in tabular format. This information is correct in Reference: Statements and Options.

Value	Action
-3	Avoid flattening both EXISTS and scalar subqueries to a join operation.
-2	Avoid flattening a scalar subquery to a join operation.
-1	Avoid flattening an EXISTS subquery to a join operation.
0	Allow the IQ optimizer to decide to flatten subqueries.
1	Ignore cost flattening EXIST, if possible.
2	Ignore cost flattening scalar, if possible.
3	Ignore cost of both EXISTS and scalar subquery.