SUBQ_MIDX in macro DSN6SPRM

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

Deprecated subsystem parameter: Non-default settings for SUBQ_MIDX are deprecated. Db2 12 supports these settings, but their use is discouraged, and support is removed in Db2 13 or later. For best results, use the default value ENABLE.

Acceptable values:	ENABLE, DISABLE
Default:	ENABLE
DSNZP`xxx`:	DSN6SPRM SUBQ_MIDX
Security parameter:	No

ENABLE: Multiple index access is allowed for queries that have subquery predicates.
DISABLE: Multiple index access is not allowed for queries that have subquery predicates.

The following example query contains such non-Boolean uncorrelated subquery predicates:

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