INLISTP in macro DSN6SPRM

Specifies the maximum number of elements in an IN-list for certain IN predicate optimizations to occur.

Acceptable values: 1–5000, 0
Default: 1000
DSNZPxxx: DSN6SPRM INLISTP
Security parameter: No
1–5000
Db2 optimizes for an IN predicate with the specified number of values, with the following optimizations:
  • Pushes the IN predicate down from the parent query block into the materialized table expression.
  • Moves a correlated IN predicate in a subquery that is generated by transitive closure up to the parent query block.
0
Disables optimization for in predicates.