15.00 - Using Global Temporary Tables and Volatile Tables to Avoid Denormalization - Teradata Database

Teradata Database Design

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

Using Global Temporary Tables and Volatile Tables to Avoid Denormalization

You can use global temporary and volatile tables to avoid the following denormalizations you might otherwise consider:

  • Prejoins
  • Summary tables and other derived data
  • This final point is important as an alternative for applications that do not require persistent storage of summary results as offered, for example, by aggregate join indexes.