Specifies the maximum number of IN-lists in a single query that can use IN-list rewrite query processing.
0 through 100
Changes Take Effect
After the DBS Control Record has been written.
Increasing the number of per-query IN-lists in rewrite processing requires more search space for join planning. Large values for MaxNumInListRewrite can lead to an increase in query parsing time. Teradata recommends that you keep this value under 10.
Setting this field to 0 effectively disables IN-list rewrite processing.