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
- 6354 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 |
How to get the definition of a view out of the sql server?
What is a constant or literal in ms sql server?
How can we delete a table in sql server?
Does index speed up select statements?
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
Do you know what is normalization of database? What are its benefits?
Can we shrink data file in sql server?
What authentication modes does sql server support?
what are cursors? : Sql server database administration
Can we insert data if clustered index is disabled?
what is the disadvantage of SQL Loder?
What happens if null values are involved in arithmetic operations?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
