17.10 - Join Indexes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.

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

See Join Indexes.