Restrictions on the Number of Columns Per Referenced Base Table - Teradata Database

Teradata Database Design
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Restrictions on the Number of Columns Per Referenced Base Table

The following restrictions apply to the number of columns per table that can be specified in a join index definition.

  • The maximum number of columns that can be specified in a join index per referenced base table is 64.
  • The maximum number of columns that can be specified in a multitable join index definition is 2,048.
  • When you specify join index row compression, then each of the column_1 and column_2 sets is limited to 64 common base table references.