Re: OPERATION COLUMN IN PLAN_TABLE

Your questions and a lot other good stuff in the performance manual.

Oracle8i Designing and Tuning for Performance Release 2 (8.1.6)
Part Number A76992-01

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/toc.htm

You'll have to be registered with OTN first.

Hope that helps.

Romeo

benazir_zardari_at_yahoo.com (benazir) wrote in message news:<35a97e60.0406020903.d1cdc16_at_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 - 20:15:59 CDT