What is an execution plan? When would you use it? How would
you view the execution plan?
- 1 Answers
- 5884 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 create hyperlink from returned sql query ?
Explain trigger classes i.e. Instead of and after trigger?
Explain the concept of view and Types of views in SQL server?
New concepts of sql server 2005 use in your project.
How to create median function?
Explain datetime2 data type in sal server 2008?
What is the purpose of floor function?
What are logical/boolean operations in ms sql server?
How can I create a report based on a query? : sql server management studio
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is row_number function?
Distinguish between commit and rollback?
Explain what is raid and what are different types of raid levels?
Explain mixed authentication mode of sql server?
What is sql view?
