16.10 - Teradata Database Index Types - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)
  • Primary index

    In general, all Teradata Database tables require a primary index because the system distributes tables on their primary indexes. Primary indexes can be:

    • Unique or nonunique.
    • Partitioned or nonpartitioned.
  • Secondary index

    Secondary indexes can be unique or nonunique.

  • Join index (JI)
  • Hash index