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.