What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 9270 Views
- Accenture, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is t sql the same as sql server?
How to find out what is the default collation in a database?
When to use Inner join & when to use subquery?
what are constraints? Explain different types of constraints? : Sql server database administration
What are the features of Embedded SQL
what are the new features in SSRS?
How do I get to sql server configuration manager?
Is sql server implemented as a service or an application? : Sql server database administration
Explain system rowset functions?
Can we delete data from a view?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What are the components of dbms?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
Can two different columns be merged into single column? Show practically?
What are the aggregate and scalar functions?
