ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What is Query Execution Plan? How does it help optimize or 
tune a database driven application?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is Query Execution Plan? How does it help optimize or tune a database driven application?
Answer
# 1
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 ?    1 Yes 0 No
Arthanari R
 
  Re: What is Query Execution Plan? How does it help optimize or tune a database driven application?
Answer
# 2
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 ?    0 Yes 0 No
Racing
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to link up the text file to a Database table? Allianz1
What do u mean by orphan users, how will u list them in the DB IBM2
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number. Value-Labs4
What is de-normalization and when do you do it?  3
Explain some DBCC commands?  4
What is the difference between temp table and table variable? Microsoft4
Can you explain the role of each service?  1
difference between sql server2000 and sql server2005 KPMG1
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500  2
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
what is hash table Teledata2
how to select a field with firstletter as capital and remaining are small letters  8
The Difference between 'Count' and 'Count(*)'  12
What is database normalization? Digicel5
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query? Infosys3
how to give input dynamically to a insert statement in sqlserver HCL2
What are functions  3
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj IBM7
What is the difference between OLEDB and ODBC CFCI3
What is the default value of CHAR type? Bosch8
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com