15.00 - Reasons to Denormalize Using Prejoins - Teradata Database

Teradata Database Design

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

Reasons to Denormalize Using Prejoins

The following items are all possible reasons for denormalizing with prejoins:

  • Performance can be enhanced significantly.
  • The method is a good way to handle situations where there are tables having fewer rows than there are AMPs in the configuration.
  • The minor entity is retained in the prejoin so anomalies are avoided and data consistency is maintained.