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
Which trace flags are enabled in sql server?
What is blocking?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is your recommendation for a query running very slow? : sql server database administration
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to change parameter value inside the report?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
what exactly sql injuction.how to overcome.....
What is global temp table?
Where are sql server user names and passwords stored in sql server?
What is truncate table?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
what is the sql equivaent of the dataset relation object ?
How to find the second highest salary of an employee?
Can you create a logon trigger in sql server 2005 express edition?