What is an execution plan? When would you use it? How would
you view the execution plan?
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
Is it safe to delete log files?
Which are the new data types introduced in sql server 2008?
Explain how to integrate the ssrs reports in application?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the difference between dbcc indexdefrag and dbcc reindex?
When a primary key constraint is included in a table, what other constraints does this imply?
How to change the ownership of a schema in ms sql server?
Can you explain what is the use of custom fields in report?
Explain the concept of view and Types of views in SQL server?
What are the differences between DDL, DML and DCL in SQL?
How can you start sql server in different modes?
Differentiate between truncate vs delete in mssql?
Find first and last day of current month in sql server
How can sql server instances be hidden? : sql server security
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?