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

Databse Processing 12e, Chapter 10a review questions Chapter 10a review questions

Student database, tell me the functionality,advantages and disadvantages of... tell me the functionality,advantages and disadvantages of student database

Er diatgrams, Ask q“A database will be made to store information about pati... Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

What are the ways in which signal can be generated, What are the ways in wh... What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

Whta is the advantage of the database management approach, Whta is the adva... Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Define the term- actors and data stores, Define the term- Actors and Data... Define the term- Actors and Data Stores Actors: An actor is the active object which drives data flow graph by producing or consuming values. Actors are attached to inputs a

Demonstrate the design of associations, Demonstrate the Design of associati... Demonstrate the Design of associations During object design phase we must design a strategy to implement associations. Association may be unidirectional or bi-directional. Wha

Create records in a table - data structures, In this exercise you will crea... In this exercise you will create ten records, each containing the following fields: student name, class:  Freshman, Sophomore, Junior or Senior, Major:  Liberal Arts or General Sci

DBMS, what is specialization? what is specialization?

What is sql, What is SQL, and why is it important? SQL stands for Struc... What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm