Re: Same index, different plan - oracle-l - FreeLists

Re: Same index, different plan

From: "Luis Fernando Cerri" <lfcerri@xxxxxxxxx>
To: paul.baumgartel@xxxxxxxxxxxxxxxxx
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?

Best regards,
Cerri



> 2008/4/4, Baumgartel, Paul <paul.baumgartel@xxxxxxxxxxxxxxxxx>:
> > All true, but the question is why a hint that says "use this index"
--
//www.freelists.org/webpage/oracle-l

References:
- Re: Same index, different plan
  - From: Hemant K Chitale
- RE: Same index, different plan
  - From: Powell, Mark D
- RE: Same index, different plan
  - From: Baumgartel, Paul

Other related posts: