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 is a partitioned view?

0 Answers  

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,

What is the purpose of the model database?

0 Answers  

Explain the purpose of indexes?

0 Answers  

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

What is difference between count (*) and count 1?

0 Answers  

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

2 Answers  

Is the log file is a part of file group?

0 Answers  

How to download microsoft sql server 2005 express edition?

0 Answers  

How do you clear a log file?

0 Answers  

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

What are the different types of columns types constraints in the sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories