zigzagdna_at_yahoo.com wrote:
> 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.
like '%string%' will not benefit from an index. like 'string%' will
using b-trees to satisfy full text case insensitive search won't work
for you.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Received on Fri Oct 05 2007 - 13:42:55 CDT
