SUBQ_MIDX in macro DSN6SPRM

Specifies whether to enable or disable multiple index access on some non-Boolean uncorrelated subquery predicates.

The following is an example of such a query:

SELECT *
  FROM T1
 WHERE (T1.C1= ? )
        OR (T1.C2 >= T1.C3
            AND T1.C4 = (SELECT T2.C1
                           FROM T2
                          WHERE T2.c2  = ?)
           )

Valid values of SUBQ_MIDX are DISABLE and ENABLE.

A value of DISABLE means that multiple index access is not allowed for queries that have subquery predicates.

A value of ENABLE means that multiple index access is allowed for queries that have subquery predicates This setting is recommended only when performance degradation is specifically identified for queries that have subquery predicates.

The default value of SUBQ_MIDX is DISABLE.