15.00 - Basing a Join Index on Foreign Key-Primary Key Equality Conditions - Teradata Database

Teradata Database Design

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

Basing a Join Index on Foreign Key-Primary Key Equality Conditions

To avoid storing redundant data, base join index definitions on foreign key=primary key predicates. Add either the primary key or the foreign key to the index definition, but not both, because the Optimizer has the intelligence to derive either from the other.