15.00 - Nonpartitioned Primary Indexes - Teradata Database

Teradata Database Design

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

Nonpartitioned Primary Indexes

The nonpartitioned primary index is the standard Teradata Database primary index. When a table is created with a nonpartitioned primary index, its rows are hashed to the appropriate AMPs and stored there in row hash order, as illustrated by the following graphic.

Rows within the same box have the same row hash value. Rows with the same color pattern have a common value for a column that is not the primary index (but might be one of the columns in a multi-column primary index).