What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 10422 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 connect php with different port numbers?
What are the different types of subquery?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I start sql server 2017?
Can one drop a column from a table?
What are the kinds of subquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to convert numeric expression data types using the cast() function?
How to rebuild the master database?
How efficient you are in oracle and SQL server?
What are the source of constraints?
List the ways in which dynamic sql can be executed?
How do I create a trace in sql server?
What are the different subsets of sql?
what is spatial nonclustered index
