15.00 - Primary Index Defaults - Teradata Database

Teradata Database Design

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

Primary Index Defaults

You should always explicitly specify a primary index or explicitly specify no primary index for your tables.

At the least, you should specify a PRIMARY KEY constraint on the column set you want to define as the primary index if you do not specify an explicit primary index.

Note that Teradata Database never creates a partitioned primary index by default.

There are no defaults for the primary index of a temporary table, which you must always declare explicitly.