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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click 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 ?    0 Yes 0 No
Arthanari R
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
any one can explain Self mapping Delegation Remote Credentials  1
What is the STUFF function and how does it differ from the REPLACE function?  1
What is the basic difference between clustered and a non-clustered index?  2
What is Trigger? Misys2
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony19
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
What are the types of backup and tell me the difference between full and differential backup? TCS3
Can you have a nested transaction? HCL3
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
Explain DBMS, RDBMS?  4
What is a stored procedure?  3
syntax for deleting the database in T SQL  3
What is a cursor in SQL Server 2000 and their types?  2
how to connect sybase to sql server 2005?. ABC1
About Indexed Views? with example? plz reply...  1
What is normalization?  5
How to create logins using windows Authentication mode?  1
What are the type of joins? When do we use Outer and Self joins?  3
What value could be assigned to Varchar Type?  2
Can you give an example of Stored Procedure?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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