15.00 - Secondary Index Types - Teradata Database

Teradata Database Design

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

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.