15.00 - Mandatory Use of Primary Indexes - Teradata Database

Teradata Database Design

Teradata Database
User Guide

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.