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

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.