On Oct 5, 1:05 pm, zigzag..._at_yahoo.com wrote:
> I am on Oracle 9.2.0.6 on Wiindows 2000, but I will like to know for
> any version of Oracle - 9.2 or later, following can be done.
>
> I have created function based indexes on upper of columns, foe
> example upper(reportedby). I have a histogram on column reportedby, it
> will really not help when query is done on upper(reportedby) in
> deciding whether one should use index vs full table scan. Is there a
> way to create histogram on upper(reportedby) similar to function based
> indexes.
>
> I have a packaged application (I cannot modify source code). There are
> several queries which use upper(reportedby) like '%JOE%' in where
> clause, I created function based index on upper(reportedby), however
> fb index does not get used. I was wondering whether it is possible to
> create histograms to influence CBO.
Did you look at Tom Kyte's site and his ideas in this area yet?
Received on Fri Oct 05 2007 - 12:21:53 CDT
