17.10 - Alternatives to Denormalization - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

Teradata continues to introduce functions and facilities that permit you to achieve the performance benefits of denormalization while running under a direct physical implementation of your normalized logical model.

Among the available alternatives are the following:

  • Views
  • Join indexes
  • Aggregate join indexes
  • Global temporary and volatile tables