What is an execution plan? When would you use it? How would
you view the execution plan?
- 1 Answers
- 6023 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are different types of schemas?
What is the difference between deallocate cursor and close cursor?
How to create a scrollable cursor with the scroll option?
How to create a trigger for insert only?
Explain Trigger with an example?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is equi join with example?
Tell me what are the essential components of sql server service broker?
How to remove duplicate rows from table except one?
when we use function instead of procedure? plz tell me the situation with ex?
Wht is Stuff in sql ser
what is datawarehouse?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
