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
- 10217 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
Different types of keys in SQL?
What is the use of floor function in sql server?
What is the use of keyword with encryption.
How to generate create table script on an existing table in ms sql server?
Explain the use of containers in ssis and also their types?
What is statement level trigger?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is self contained sub query?
What are the approximate numeric data types?
What is lock escalation? : sql server database administration
What is the difference between index seek vs. Index scan?
How to automatically create a log when an exception is being received into SQL Server?
Determine when to use stored procedure to complete sql server tasks?
What are the aggregate and scalar functions?
What is the function of inner join?
