Analyzing execution plans is a key tool when analyzing query performance. As most of you are aware there are two ways of analyzing query plans, namely ‘Include Actual Execution Plan’ and ‘Display Estimated Query Plan’
The Include Actual Execution Plan option will provide the execution plan after the completion of the query. However, this option is not very useful when dealing with long running queries.
Read more here
No comments:
Post a Comment