15.00 - Query Workload - Teradata Database

Teradata Database Design

Teradata Database
User Guide

Query Workload

The query workload is a mix of tactical and strategic requests:

  • There is a modest volume of short-running single‑AMP (primary index) queries.
  • There are many ad hoc queries follow a general pattern of comparing current-month-to-date sales to the same days of the previous month, or to the same days of the same month of the previous year for a few product code values.
  • Some queries analyze agent performance, usually over an interval of a calendar quarter or less.
  • Some queries examine sales trends over the previous 24 full months, usually for most or all product code values.
  • All the tables that support the workload have different primary indexes.

    The sales table is frequently joined to relatively small tables containing information about each product code and each sales agent.