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
- 6416 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 insert data with null values?
What is transaction server consistency?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How to delete all rows with truncate table statement in ms sql server?
What is a cursor, index in sql?
What is a trigger what are the advantages of trigger?
Explain different types of index?
What are the advantages of sql azure?
How do you trace the traffic hitting a sql server?
What is federation member?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the difference between coalesce() & isnull()?
what is the difference between openrowset and openquery?
What is compression - row-level and page-level compression?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
