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