-
Operation Column In Plan Table
Hi,
I am using an Oracle diagnostic tool “EXPLAIN PLAN” for evaluating the performance of SQL statements. I am using ORACLE 8.1.7.
The script utlxplan.sql create the table PLAN_TABLE, as we know.
In plan table several columns are available in order to evaluate the performance of the SQL.
There are several rows available in the OPERATION column of the PLAN_TABLE after generating the explain plan for a SQL.
With regards to the OPERATION column of the PLAN_TABLE, I wanted to know about the following 6 rows :
1. NESTED LOOPS
2. INDEX RANGE SCAN
3. INDEX UNIQUE SCAN
4. TABLE ACCESS BY ROWID
5. FILTER
6. HASH JOIN
Could someone give me the detail of the above rows?
This will be highly appreciated.
Thanks
BEnazir
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|