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

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.