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

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

How do you read transaction logs

1 Answers  

Explain the collation?

0 Answers  

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

What does top operator do?

0 Answers  

What do you mean by an execution plan? Why is it used?

0 Answers  

Is null vs coalesce?

0 Answers  

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories