Reporting queries are query:
- executed periodically
- to create well-known, pre-defined metrics
- that will answer questions about the financial and operational health of a system (business).
Although reporting queries tend to be static, minor changes are common. From one use of a given reporting query to the next, a user might choose to shift focus by varying a date range, geographic location or a brand name.
Because this query are very well known in advance, the DBA can optimize the system specifically for these queries to execute them very rapidly by using:
- data placement methods (e.g. partitioning and clustering)
- and/or auxiliary data structures (e.g. materialized views and indexes).