16.10 - Teradata Database Index Types - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
klx1480972732157.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.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