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 ad hoc queries that 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 small number of product code values.
- There are queries that analyze agent performance, typically over an interval of a calendar quarter or less.
- There are queries that examine sales trends over the previous 24 full months, typically 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.