16.10 - Join Indexes - 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)

A join index is an indexing structure containing columns from one or more base tables and is generally used to resolve queries and eliminate the need to access and join the base tables it represents.

Teradata Database join indexes can be defined in the following general ways.

  • Simple or aggregate
  • Single-table or multitable
  • Hash-ordered or value-ordered
  • Complete or sparse

For details, see “Join Indexes.”