RE: Same index, different plan

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 04 Apr 2008 13:23:50 -0600
Message-Id: <200804041923.m34JNs8u006142@mail75.megamailservers.com>


because the index hint is synonymous with index_rs. Both request an index range scan - and the CBO obeyed the hint ! :-) If you want something else you have to say it: index_ffs or index_ss (for skip scan) and I think there are a few more.

At 12:27 PM 4/4/2008, Baumgartel, Paul wrote:
>All true, but the question is why a hint that says "use this index"
>produces a different type of scan than a query without the hint that
>uses the index anyway.
>
>
>Paul Baumgartel
>CREDIT SUISSE
>Information Technology
>Prime Services Databases Americas
>One Madison Avenue
>New York, NY 10010
>USA
>Phone 212.538.1143
>paul.baumgartel_at_credit-suisse.com
>www.credit-suisse.com
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 04 2008 - 14:23:50 CDT

Original text of this message