15.00 - Row-partitioned and Nonpartitioned Primary Indexes - Teradata Database

Teradata Database Design

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

Row-partitioned and Nonpartitioned Primary Indexes

A primary index can be either row-partitioned or nonpartitioned. Primary indexes for hash and join indexes can also either be hash‑ or value‑ordered, while primary indexes for all other table types are hash‑ordered only.

The decision to define which of the two choices for a table depends on how its rows are most frequently accessed (see “Row‑Partitioned and Nonpartitioned Primary Index Access for Typical Operations” on page 403 and “Single‑Level Partitioning Case Studies” on page 370). This topic describes the differences between the two types as well as their relative advantages and disadvantages.