17.10 - Process Review - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
Language
English (United States)

The following are the high-level stages in the physical design process:

  1. Identify all index and partitioning candidates.
  2. Review table demographics, then verify or modify index and partitioning choices.
  3. Evaluate denormalization possibilities, including dimensional views, then verify or modify index and partitioning choices.
  4. Evaluate derived data, then verify or modify index and partitioning choices.
  5. Implement the system and initiate production processing.
  6. Track changing demographics.
  7. Review indexes and partitioning periodically to ensure they are still the best choices.
  8. Perform appropriate EXPLAIN request modifiers periodically to track whether defined indexes are being selected for query processing by the Optimizer and whether the current partitioning is still facilitating row and column partition elimination.
  9. Reevaluate table use.
  10. Document any changes.
  11. Archive older versions of your findings for use in analyzing trends.