16.10 - MaxNumInListRewrite - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Specifies the maximum number of IN-lists in a single query that can use IN-list rewrite query processing.

Field Group

Performance

Valid Range

0 through 100

Default

2

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

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.

Related Topics

  • For more information on large IN-list processing, see SQL Request and Transaction Processing.
  • For information on other DBS Control fields related to IN-list processing, see InListRewriteOption and InListRewriteThreshold.