15.00 - Reasons to Denormalize Using Join Indexes - Teradata Database

Teradata Database Design

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

Reasons to Denormalize Using Join Indexes

The following items are all reasons to use join indexes to “denormalize” your database by optimizing join and aggregate processing:

  • Update anomalies are eliminated because the system handles all updates to the join index for you, ensuring the integrity of your database.
  • Aggregates are also supported for join indexes and can be used to replace base summary tables.
  • Related Topic

    For a full description of join indexes, see Chapter 11: “Join and Hash Indexes”.