15.00 - Case Study 3: Highly Singular Primary Index Values - Teradata Database

Teradata Database Design

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

Case Study 3: Highly Singular Primary Index Values

A carefully selected NUPI distributes the rows of a table nearly as evenly as a UPI. If you are fortunate, the NUPI column might never contain duplicates.

The illustration shows how evenly customer table rows are hashed when a NUPI is defined on the sales_employee_number attribute.