16.10 - Primary Keys and Primary Indexes - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)
Last Update
2018-04-25

The following table summarizes the differences between keys and indexes, using the primary key and primary index for purposes of comparison.

Primary Key Primary Index
Important element of logical data model. Not used in logical data model.
Used to maintain referential integrity. Used to distribute and retrieve data.
Must be unique to identify each row. Can be unique or nonunique.
Values cannot change. Values can change.
Cannot be null. Can be null.
Does not imply access path. Defines the most common access path.
Not required for physical table definition. Required for physical table definition.