Secondary Index Types - Teradata Database

Secondary Index Types

Unique secondary index (USI)

Nonunique secondary index (NUSI):

Hash‑ordered on all columns.

This is the default ordering when you do not specify an ORDER BY clause.

Hash‑ordered on a single column with no ALL option.

Value‑ordered on a single column with no ALL option.

Hash‑ordered on a single column with the ALL option.

Value‑ordered on a single column with the ALL option.

See the description of the CREATE INDEX statement in SQL Data Definition Language for details.