Histograms on Columns for CBO

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.
Received on Fri Oct 05 2007 - 12:05:37 CDT