It is very common in Data Warehousing (DWH). These differences are described in terms of SLE, size, complexity and throughput.
| Strategic Queries | Tactical Queries |
|---|---|
| Strategic queries represent business questions that are intended to draw strategic advantage from large stores of data. | Tactical queries are short, highly tuned that facilitate action-taking or decision-making in a time-sensitive environment. They usually come with a clear service level expectation and consume a very small percentage of the overall system resources. |
| Strategic queries are often complex queries, involving aggregations and joins across multiple tables in the database. They are sometimes long-running and tend not to have a strict service level expectation. | Tactical queries are usually repetitively executed and take advantage of techniques such as request (query plan) caching and session-pooling. |
| Strategic queries are sometimes ad hoc. They may require significant database resources to execute and they are often submitted from 3rd party tools. |