Re: OPERATION COLUMN IN PLAN_TABLE

On 2 Jun 2004 10:03:47 -0700, benazir_zardari_at_yahoo.com (benazir) wrote:

>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

Just look them up in the online documentation at http://tahiti.oracle.com

--
Sybrand Bakker, Senior Oracle DBA