15.00 - Guideline for All Primary Indexes - Teradata Database

Teradata Database Design

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

Guideline for All Primary Indexes

Define the primary index for a table on as few columns as possible. Retrievals on columns that do not match the entire primary index do not use the primary index to retrieve the matching rows.

Hashing efficiency increases as the number of primary index columns decreases.