top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is an execution plan? When would you use it? How would you view the execution plan?

0 votes
226 views
What is an execution plan? When would you use it? How would you view the execution plan?
posted Nov 27, 2014 by Vinitha

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the SQL Server query optimizer for a stored procedure or ad-hoc query and is a very useful tool for a developer to understand the performance characteristics of a query or stored procedure since the plan is the one that SQL Server will place in its cache and use to execute the stored procedure or query. From within Query Analyzer is an option called “Show Execution Plan” (located on the Query drop-down menu). If this option is turned on it will display query execution plan in separate window when query is ran again.

answer Nov 27, 2014 by Manikandan J
...