Interested to Buy Any Domain ? << Click Here >> for more details...
What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 10238 Views
- Accenture, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to encrypt Strored Procedure in SQL SERVER?
How to return the date part only from a sql server datetime datatype?
What is updatable resultset?
What is microsoft sql server?
How can sql injection be stopped? : sql server security
What is a matrix in ssrs?
How to drop an existing user defined function in ms sql server?
What is save transaction and save point?
how many bits ip address consist of? : Sql server database administration
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What are the different types of lock modes in sql server 2000?
What are the different types of indexes?
What is global temp table?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How you can minimize the deadlock situation?
