Interested to Buy Any Domain ? << Click Here >> for more details...
What is an execution plan? When would you use it? How would
you view the execution plan?
- 1 Answers
- 6481 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
What are cursors stored procedures and triggers?
What is the osql utility?
What are exact numeric data types in ms sql server?
Can group by be used without aggregate functions?
How to start sql server browser service?
Do you know what guidelines should be followed to help minimize deadlocks?
Explain about the command-line tool SQLCMD?
explain different levels of normalization? : Sql server database administration
Describe different Processing Modes offered by SSRS?
How to run queries with sql server management studio express?
How will you optimize a stored procedure optimization?
Why are views required in the sql server or in any other database?
What is a schema in ms sql server 2005?
What is the new security features added in sql server 2016? : sql server security
What is SQL Azure Data sync?
