15.00 - Alternatives to Denormalization - Teradata Database

Teradata Database Design

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

Alternatives to Denormalization

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 fully normalized logical model.

Among the available alternatives are the following:

  • Views
  • Hash and join indexes
  • Aggregate join indexes
  • Global temporary tables