15.00 - Reasons Not to Denormalize Using Derived Data - Teradata Database

Teradata Database Design

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

Reasons Not to Denormalize Using Derived Data

The following items deal with the issues of derived data without denormalizing user base data tables:

  • Aggregate join index (see “Aggregate Join Indexes” on page 552)
  • Global temporary table with derived column definitions
  • View with derived column definitions