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
- 10239 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
How to use subqueries with the in operators in ms sql server?
What is a performance monitor?
Explain syntax for disabling triggers?
How would you use user_constraints table in DB?
What are triggers? How do you invoke a trigger on demand?
How to create a trigger for insert only?
How many clustered indexes there can be on table ?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are the ways available in sql server to execute sql statements?
In what version of sql server were synonyms released?
What is data compression?
What is bookmark link in ssrs?
Is sql server is free?
Why are sql functions used?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
