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
- 6343 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 is an indexed view?
What is 1nf normalization form?
What are a database and a data warehouse?
Explain what role entity and relationship play in an ER diagram.
Will sql server 2005 allow you to reduce the size of a column?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What are .mdf files?
What are null values in ms sql server?
what is an extended stored procedure? : Sql server database administration
What is transact-sql ddl trigger?
what are candidate key, alternate key and composite key? : Sql server database administration
Why does sql studio use a single registered database repository? : sql server management studio
What is 'Join' and explain its various types.
How can we solve concurrency problems?
when would you go for denormalization? : Sql server database administration
