All Forums General
chill3che 99 posts Joined 10/12
04 Jan 2014
Strategic Vs Tactical queries

Greetings experts,
Can you please elucidate what is stragetic and tactical queries and what are the ideological differences between them.
I often come across them through developer forum and a bit confusing.

Thanks, Cheeli
Raja_KT 1246 posts Joined 07/09
04 Jan 2014

Hi Cheeli,
It is very common in DWH. TD manual has vividly described them, so I copy and paste from there:

Tactical queries are short, highly tuned queries 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.


Tactical queries are usually repetitively executed and take advantage of techniques such as

request (query plan) caching and session-pooling.




Strategic queries represent business questions that are intended to draw strategic advantage

from large stores of data.Strategic queries are often complex, 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.


Strategic queries are often ad hoc. They may require significant database resources to execute,

they are often submitted from third-party tools, and they can take advantage of session



So you see the importance  in terms of SLE ,size, complexity, throughput.






Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

alihammad 16 posts Joined 03/11
15 Sep 2014

Very well explained. Thank you

You must sign in to leave a comment.