Explain query execution plan, Database Management System

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

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
Related Questions
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 : 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? 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 (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

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? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

4. Describe three ways to handle missing field values

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 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 Example: To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;