Analyze Function-Based Index Ignored or Not Working

welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com

Oracle Analyze Function-Based Index Ignored or Not Working

Oracle Tips by Burleson Consulting
June 29, 2011

Question: I have created a function-based index on a table column, yet
when I check by execution plan, the function-based index is ignored by
the optimizer.

Why does Oracle ignore a function-based index?

How do I force Oracle to use a function-based index?

Answer: : The optimizer is aware of all indexes at index creation
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------