Re: Same index, different plan
Date: Fri, 4 Apr 2008 16:13:29 -0300
The hint says "use this index", but the scan method is chosen by CBO based on the available statistics.
Did you take a trace 10053?
> 2008/4/4, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>:
> > All true, but the question is why a hint that says "use this index"