Wednesday, February 9, 2011

Difference between Strategic Queries and Tactical Queries?

Strategic Queries
Strategic queries represent business questions that are intended to draw strategic advantage from large stores of data.
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.
Strategic queries are sometimes ad hoc. They may require significant database resources to execute and they are often submitted from third-party tools.

Tactical Queries
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.

9 comments:

  1. Thanks. I'm ready for my certification exam and this clarification has helped me a lot.

    ReplyDelete
  2. Thanks for the explanation. Now I undestand that.

    ReplyDelete
  3. Thanks a lot sir....

    ReplyDelete
  4. Yogesh Bharadwaj C.AMarch 6, 2013 at 8:36 AM

    Thanks a lot sir......good, simple explanation....

    ReplyDelete
  5. One more point to Tactical Qry - They are often used to identify business trends and patterns.

    ReplyDelete
  6. thanks, simple and clear = always welcome!

    ReplyDelete
  7. is tactical query are used to determine business trends and pattern in teradata ??

    ReplyDelete