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

Teradata Database Design

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

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.