16.20 - Teradata Database Index Types - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
  • 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