RE: CBO problem

You have to read Note:212809.1 Limitations of the Oracle Cost Based Optimizer and notes on bind variable peeking and notes on histograms. Apart of bugs there are some fundamental problems in optimization business, in short:

-Bind variables basically eliminate histograms.  Bind variable peeking is just a plain guess.
-Histograms do not always represent accurate data distribution.
-In many cases multi column predicate cardinalities is just a plain guess.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nirmalya Das Sent: 17. júlí 2006 17:20
To: David Sharples
Cc: oracle-l_at_freelists.org
Subject: Re: CBO problem

I thought the "stats" collection is one of the most important events to help CBO finding the best QEP......

Are you sure you want me to turn it off?

Quoting David Sharples <davidsharples_at_gmail.com>:

> do you need to collect stats, if not turn it off
>
> On 17/07/06, Nirmalya Das <nirmalya_at_hln.com> wrote:
>>
>>
>> I remember a while back there was a thread on this particular issue
>> the "Automatic Statistics Gathering" can sometimes produce
>> undesirable results and QEP. I tried to search the archives of this
>> list but could not locate the thread.
>>
>> Does any one remember that or have some suggestions on using the
>> "Automatic Statistics Gathering".
>>

--
http://www.freelists.org/webpage/oracle-l


Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
http://www.freelists.org/webpage/oracle-l