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
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.