Re: CBO problem

From: Nirmalya Das <nirmalya_at_hln.com>
Date: Mon, 17 Jul 2006 10:20:23 -0700
Message-ID: <20060717102023.cfmq9gkwco08884k@www.hln.com>

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

Received on Mon Jul 17 2006 - 12:20:23 CDT