17.10 - MaxNumInListRewrite - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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 Information

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