What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 9557 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
What do you mean by an execution plan? Why is it used?
You want to implement the one-to-one relationship while designing tables. How would you do it?
what is checksum in sql server.........???
What is temporary table in sql server? Why we use temp table?
What is the log shipping?
What are the different ways you can create databases in sql server?
How to execute function in stored procedure sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Differentiate between sql temp table vs table variable?
Describe the left outer join & right outer join. : sql server database administration
What is trigger explain with program?
What does set rowcount do?
What are parameterized reports?
What are a database and a data warehouse?
