What is an execution plan? When would you use it? How would
you view the execution plan?
- 1 Answers
- 6031 Views
- I also Faced
- E-Mail Answers
Answer Posted / sumit
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to declare a cursor with "declare ... Cursor" in ms sql server?
What are two difference between sql azure and azure tables?
What is a recursive stored procedure in sql server?
Does windows server 2016 come with sql server?
What is NOT NULL Constraint in sql server 2012?
How to enable/disable indexes?
What is the importance of three tier architecture?
‘Order by’ is not allowed in a view how can you sort information from a view?
What happens when transaction log is full?
What are trace flags?
What are relationships and mention different types of relationships in the dbms
Does an index slow down updates on indexed columns?
What is the architecture of ms sql reporting service?
What is the web service used for reporting services?
What are the 2 types of classifications of constraints in the sql server?
