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 built in functions?

0 Answers  

Is resultset an interface?

0 Answers  

what is a correlated sub-query? : Sql server database administration

0 Answers  

What is difference between primary key and foreign key?

0 Answers  

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

How to list all login names on the ms sql server?

0 Answers  

What are Row versions of DataRow?

0 Answers  

How many categories of data types used by sql server?

0 Answers  

How are the exceptions handled in sql server programming?

0 Answers  

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

Can you explain what is the use of custom fields in report?

0 Answers  

When columns are added to existing tables, what do they initially contain?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories