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

Cascading, what is cascading? what is rollback cascading? please explain in... what is cascading? what is rollback cascading? please explain in detail

Drop table command, DROP TABLE Command: When an existing object is not ... DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

Which component is not included in database environment, Which component is... Which component is not included in database environment ? A users component is not included in database environment.

Explain Lock-Based protocols, # ???? .. # ???? ..

Mixed fragmentation, Mixed fragmentation: Sometimes, horizontal fragmentati... Mixed fragmentation: Sometimes, horizontal fragmentation or vertical fragmentation of a database schema by itself is insufficient to sufficiently distribute the data for some appli

Which operator is cartesian product in relational algebra, Which operator i... Which operator is Cartesian product in relational algebra? Cartesian product in relational algebra is a binary operator. (It requires two operands. e.g., P X Q)

Ldb hierarchy there should exist one get statement, It is mandatory that fo... It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False.  It is not essential.

What is data block, What is data block? Data Block - In oracle the data... What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace

How nulls are treated in comparison operator, How nulls are treated in comp... How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

Windows 8 Administrative Tools, Which two tools are used to administer user... Which two tools are used to administer users for Active Directory?