15.00 - Normalized Table Set - Teradata Database

Teradata Database Design

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

Normalized Table Set

The second set of tables is normalized. By defining a NUPI on part_num, you can determine the current price of any part by reading only one additional block on the same AMP that holds the part table row.

With a composite UPI defined over part_num and effective_date, the lookup cost for determining the current price of a part would be substantially higher.