Scaling Oracle 8i - Histograms

Hi,

I am not sure If James Morle is part of this list but i know people how are on par with him and who answer here .. so i Shoot ...

In His Book in Scaling Oracle 8i in Page Number 278. [ He is tlaking here about the Cursor Head and Cursor Body and how Bind Variables are handled]
<Quote>

The Optimizer Plan can also change between executions, owing to the existence of histograms for the value for a column. If a values is supplied that can be approached in a more effeciaent way as a Reult of cardinality, then a new plan is created and put into a new body ....
</Quote>

All this while i was thinking that Bind variables dont use Histograms and i here i find a diffrent stmt. Since if we use Hard Coded Values then there will be two Cursor Heads since the Hash Value for them will be diffrent and hence we will use Histograms since the Optimizer Knows what value we have passed.

Pls Enlighten.

Thanks.

Regards,
Ganesh R Received on Sun Jun 08 2003 - 22:30:52 CDT