Re: Same index, different plan
From: Luis Fernando Cerri <lfcerri_at_gmail.com>
Date: Fri, 4 Apr 2008 16:13:29 -0300
Message-ID: <329b3afe0804041213n3b9807dveb97fbadc37cce0d@mail.gmail.com>
Date: Fri, 4 Apr 2008 16:13:29 -0300
Message-ID: <329b3afe0804041213n3b9807dveb97fbadc37cce0d@mail.gmail.com>
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?
Best regards,
Cerri
> 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"
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 04 2008 - 14:13:29 CDT