Table of Contents

About

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.

Performance

The central difference between reporting queries and ad hoc queries is that there is a high degree of foreknowledge that is available in order to tune the database.

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

See SQL - Query Performance