Re: Oracle ignoring function-based index - why?

On Mon, 25 Jul 2005 17:59:51 +0200, Maxim Demenko <mdemenko_at_arcor.de> wrote:

>sybrandb_at_yahoo.com schrieb:
>> You should leave that option out for the time being.
>>
>
>Could you please elaborate more on this ?
>Do you know some cons for combination "MONITORING + GATHER STALE" ? Some
>, i am aware of ( dop 32767 for calculation of index stats, histograms
>calculations with nls_territory not 'AMERICA' resulting in ORA-00600)
>can be easily worked around...
>I'd like to know, whether there are arguments to not implement this
>method of statistics gathering.
>
>Best regards
>
>Maxim

I don't know any cons, but as the OP didn't use CBO, I assumed he didn't alter all the tables to monitoring in the last few days. So gather stale would do exactly nothing.

--
Sybrand Bakker, Senior Oracle DBA