Explain query execution plan?

- Optimizer available in SQL Server optimizes code to be effectively executed.

- A query execution plan demonstrates how this optimizer would run the query.

- Query execution plan can be viewed by:

- Using Show Execution Plan option available in Query Analyser,

- Displaying Estimated Execution Plan on query dropdown menu,

- Use SET SHOWPLAN_TEXT ON command before running a query and capturing execution plan event in a SQL Server Profiler trace.

 

Posted Date: 9/7/2013 3:05:59 AM | Location : United States

Ask an Expert

Related Discussions:- Explain query execution plan, Assignment Help, Ask Question on Explain query execution plan, Get Answer, Expert's Help, Explain query execution plan Discussions

Write discussion on Explain query execution plan
Your posts are moderated

Write your message here..

Related Questions

What is the aim of logical schema, What is the aim of logical schema ? ... What is the aim of logical schema ? The main motive of the logical schema is to ensure the portability of procedures and models on various physical schemas at runtime.

What are the uses of odbc, What are the uses of ODBC? Under what circumstan... What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

What is a transaction? and how does it differs from update, wh wh

Data redundency, How to reduce data redundency How to reduce data redundency

What is system log, What is system log?  What are the entries?       An... What is system log?  What are the entries?       Ans:  The system log that is generally written on stable storage contains the redundant data required to recover from volatile

List the string operations supported by sql, List the string operations sup... List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas

Explanation on data sharing, Explanation on Data Sharing? Explanation on Data Sharing?

Example of weak entity, Consider the entity type dependent related to emplo... Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth d

Update operations, The Update Operations : Update operations are used fo... The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

What is recovery?, What Is Recovery?  During the life of a transaction, ... What Is Recovery?  During the life of a transaction, i.e., a after the start of a transaction but before the transaction commits, various changes may be made in a database state