Re: Function Based Index

  • From: Purav Chovatia <puravc@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 10 Sep 2012 20:51:03 +0530

Forced to use the index and the cost that CBO comes up with, is higher.
Also verified the same with a 10053 trace. Cannot understand why is the
cost high?
Any way that any of you folks know, except hints, to make the CBO use the
index and go for an index range scan?


On Mon, Sep 10, 2012 at 3:34 PM, Purav Chovatia <puravc@xxxxxxxxx> wrote:

> KEEP pool is configured for the instance. And the table is configured to
> be cached in the KEEP pool.
> Could that be the reason for either of the observations that I have made?
> thanks


Other related posts: