17.05 - Primary Index and Primary AMP Index - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

Primary indexes for temporal tables must be non-unique (NUPIs).

Temporal columns, or the component columns of temporal derived period columns, cannot be included in primary indexes or primary AMP indexes.

If the CREATE TABLE statement for a nonpartitioned table does not specify either PRIMARY INDEX, PRIMARY AMP INDEX, or NOPI, automatic creation of a primary index is controlled by the setting of DBS Control field PrimaryIndexDefault. For more information see Teradata Vantage™ - Database Utilities , B035-1102 .

If the CREATE TABLE statement for a partitioned table does not specify either PRIMARY INDEX, PRIMARY AMP INDEX, or NO PRIMARY INDEX, the table will be created as a NoPI table.