What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 10432 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
What is sql or structured query language?
What are the kinds of subquery?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain system functions or built-in functions? What are different types of system functions?
What is subquery? Explain the properties of a subquery?
what is the difference between openrowset and openquery?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is temporary table in sql server? Why we use temp table?
Can we shrink data file in sql server?
What are the different SQL Server Versions you have worked on?
What are the different subsets of sql?
What are the different types of subquery?
Does view occupy space?
Why use identity in sql server?
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?
