Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is Query Execution Plan? How does it help optimize or
tune a database driven application?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is Query Execution Plan? How does it help optimize or tune a database driven application?..

Answer / arthanari r

When hte SQL statement is executed Oracle designs an
execution plan for it. This execution plan is basically a
step by step instruction for how the statement must be
executed. That is, the order in which tables are read, if
indexes are used, which join methods are used to join
tables and so on. The execution plan for an SQL statement
can be viewed with the explain plan statement. The query
execution plan is elaborated during an SQL statement's
parse phase.

Is This Answer Correct ?    7 Yes 0 No

What is Query Execution Plan? How does it help optimize or tune a database driven application?..

Answer / racing

When the SQL statement is executed Oracle designs an
execution plan for it. This execution plan is basically a
step by step instruction for how the statement must be
executed. That is, the order in which tables are read, if
indexes are used, which join methods are used to join
tables and so on. The execution plan for an SQL statement
can be viewed with the explain plan statement. The query
execution plan is elaborated during an SQL statement's
parse phase.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the encryption mechanisms in sql server?

0 Answers  

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

What do you know about system database? : SQL Server Architecture

0 Answers  

How to create a local temporary stored procedure?

0 Answers  

What does it mean to normalize a database and why would you do it?

0 Answers  

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  

Is trigger fired implicitely?

2 Answers  

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

How to create user defined functions with parameters?

0 Answers  

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

Characterize join and name diverse sorts of joins?

0 Answers  

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories