OPERATION COLUMN IN PLAN_TABLE

From: benazir <benazir_zardari_at_yahoo.com>
Date: 2 Jun 2004 10:03:47 -0700
Message-ID: <35a97e60.0406020903.d1cdc16@posting.google.com>

Hi,

I am using an Oracle diagnostic tool &#8220;EXPLAIN PLAN&#8221; 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 Received on Wed Jun 02 2004 - 12:03:47 CDT