Primary Index Value Retrieval Access: Definition - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.