Reporting queries are query:
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.
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: