Operation Column In Plan Table

[Benazir]

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

[slimdave]

As ever, this is documented.

http://download-west.oracle.com/docs...plan.htm#23465

Get used to going to http://tahiti.oracle.com and searching the documentation.

[Mr.Hanky]

Originally posted by slimdave

Get used to going to http://tahiti.oracle.com and searching the documentation.

HEY!! If everyone did that, we would be denied the luxury of pissing you off on a regular basis.



Nuttin but love for you Dave.

[slimdave]

Originally posted by Mr.Hanky
HEY!! If everyone did that, we would be denied the luxury of pissing you off on a regular basis.

Oh no, there's plenty more ways of doing that. Asking about how to improve buffer cache hit ratio would be a good one.

[waitecj]

How do I improve buffer cache hit ratio?....

[abhaysk]

Originally posted by waitecj
How do I improve buffer cache hit ratio?....

Execute f***ed up queries frequently ( consistent gets to physical reads is toooooooooooooooo high .. may be of ratio 10000000:1 or even high )

[slimdave]

Originally posted by waitecj
How do I improve buffer cache hit ratio?....

... or use hash joins. that does it very nicely.

[nagarjuna]

Originally posted by slimdave
... or use hash joins. that does it very nicely.

What is the range of hit ratios for Ur databases? Just curious..

[slimdave]

99.999%

Seriously.

[abhaysk]

Mine 100%

(PS dont get your self stupid by asking "how did you achive this")