What is Query Execution Plan? How does it help optimize or
tune a database driven application?
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
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are points to remember while using the fillfactor argument?
What are the main sources of data?
How to rename an existing column with sql server management studio?
What is sub-query in sql server?
What is the difference between resultset and resultsetmetadata?
how would you improve etl (extract, transform, load) throughput?
Write a SQL queries on Self Join and Inner Join.
Can we update data in a view?
What is the sql case statement used for?
How to sort query output in descending order in ms sql server?
How to write a query with a full outer join in ms sql server?
How to use group functions in the select clause in ms sql server?
What is the sql server 2000 version number?
How to delete an existing database user?