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
- 6488 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 |
Explain features and concepts of analysis services?
What is explicit cursors?
how to avoid cursors? : Sql server database administration
Which TCP/IP port does SQL Server run on?
What is the maximum size per database for sql server express?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Why we are using the sql language?. What is the purpose of using this?
What is use of @@ spid in sql server?
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!
How to assign null values to variables or columns?
How to write character string constants or literals in ms sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
-
Oracle (3253) - 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)
