17.10 - Teradata Index Types - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)
  • Primary index
    In general, all 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