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
- 10352 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 convert a numeric expression from one data type to another?
Can I work with several databases simultaneously? : sql server management studio
What are types of storage modes? : sql server analysis services, ssas
How many levels of sp nesting are possible?
What is a natural primary key?
how to use DTS package in 2000,2005,2008 in sql server
What is the difference between functions and scalar functions?
What is bookmark link in ssrs?
List all the types of user-defined functions?
What is filter index?
What are the types of dml?
What is normalization and denormalization in sql server?
Explain syntax for viewing, dropping and disabling triggers?
What are rows and columns?
Explain foreign key in sql server?
