Re: Oracle ignoring function-based index

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Mon, 25 Jul 2005 17:59:51 +0200
Message-ID: <42e50d7f$0$16380$9b4e6d93@newsread4.arcor-online.net>

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 Received on Mon Jul 25 2005 - 10:59:51 CDT

Re: Oracle ignoring function-based index - why?