When a query goes complicated and data involved is huge, query plan reveals the query execution sequence and helps to optimize the query [1].
In MSSQL Server Management Studio, after opening a query window, one can choose "Query -> Display Estimated Execution Plan" to see the estimated query plan, and select "Include Actual Execution Plan" to show actual query plan in the result. [2] is a very good introduction.
[1] Query plan
[2] SQL Server Query Execution Plan Analysis
Tuesday, November 29, 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment