Working with Join Indexes | CREATE JOIN INDEX | Teradata Vantage - 17.10 - Maximum Number of Indexes Definable Per Data, Hash, or Join Index Table - Advanced SQL Engine - Teradata Database

Up to 32 secondary, hash, and join indexes, in any combination, can be defined for a table.

Each multicolumn NUSI defined with an ORDER BY clause counts as two consecutive indexes in this calculation. See Why Consecutive Indexes Are Important For Value-Ordered NUSIs.