15.00 - 15.10 - Teradata Database Indexes - Teradata Database

Teradata Database Introduction to Teradata

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)
Last Update

An index is a physical mechanism used to store and access the rows of a table. Indexes on tables in a relational database function much like indexes in books, they speed up information retrieval.

In general, Teradata Database uses indexes to:

  • Distribute data rows.
  • Locate data rows.
  • Improve performance.
  • Indexed access is usually more efficient than searching all rows of a table.

  • Ensure uniqueness of the index values.
  • Only one row of a table can have a particular value in the column or columns defined as a unique index.

    Teradata Database supports the following types of indexes:

  • Primary
  • Partitioned Primary
  • Secondary
  • Join
  • Hash
  • Special indexes for referential integrity
  • These indexes are discussed in the following sections.