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.
Thanks. I'm ready for my certification exam and this clarification has helped me a lot.
ReplyDeleteThanks for the explanation. Now I undestand that.
ReplyDeleteThanks a lot sir....
ReplyDeleteThanks a lot sir......good, simple explanation....
ReplyDeleteThanks alot
ReplyDeleteOne more point to Tactical Qry - They are often used to identify business trends and patterns.
ReplyDeletethanks, simple and clear = always welcome!
ReplyDeleteis tactical query are used to determine business trends and pattern in teradata ??
ReplyDeleteWell explained Thanks..
ReplyDeleteGreat and that i have a keen present: What Renos Add Value whole house renovation cost
ReplyDelete