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

Explain concurrency control, Explain concurrency control? Concurrency ... Explain concurrency control? Concurrency control Oracles multiversion concurrency control varies from the concurrency mechanism used by some other data base vendors. Read

System level permissions-data control, System level permissions : With the ... System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI

What is association, What is association? Give an example of association ... What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

List two restrictions that are applied on the modification, List two restri... List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

What is a name, What is a Name? A user-supplied name is used for identi... What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

Explain derived and non-derived attribute, Explain Derived and Non-Derived ... Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

FIELDS, 4. Describe three ways to handle missing field values 4. Describe three ways to handle missing field values

Define variable-length records arise in database, What are the ways in whic... What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o

What are the issues are formed while selecting a database, What are the Iss... What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua

Using column aliases-data manipulation language, Using Column aliases E... Using Column aliases Example: To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;