15.00 - Performance Impact of Sparse Join Indexes - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Performance Impact of Sparse Join Indexes

A sparse index can focus on the portions of the tables that are most frequently used to do the following things.

  • Make the costs for maintaining an index proportional to the percent of rows actually referenced in the index.
  • Make request access faster where the resulting sparse index is smaller than a standard join index.
  • Reduce the storage requirements for a join index where possible.