15.00 - Primary Index Value Retrieval Access: Definition - Teradata Database

Teradata Database Design

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

Primary Index Value Retrieval Access: Definition

An access column is one that is commonly used as a valued predicate in a WHERE clause.

While it is true that the column set chosen to be the primary index for a table is often the same column set that defines the primary key, it is also true that primary indexes are often composed of fields that are neither unique nor components of the primary key for the table.