15.00 - Mandatory Use of Primary Indexes - Teradata Database

Teradata Database Design

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

Mandatory Use of Primary Indexes

Except for NoPI tables, column‑partitioned tables, column‑partitioned join indexes (see “NoPI Tables, Column‑Partitioned Tables, and Column-Partitioned Join Indexes” on page 280), and global temporary trace tables, each Teradata Database table, hash, and join index must have a primary index.

If you fail to explicitly define a primary index when you create a table or join index, Teradata Database uses one of several situation-dependent default strategies to define a primary index or not to define a primary index for the table or join index. See “Primary Index Defaults” on page 263 for details. Note that Teradata recommends to explicitly specify a primary index or specify no primary index rather than depend on the system-determined default.