RE: Same index, different plan

From: Baumgartel, Paul <>
Date: Fri, 4 Apr 2008 15:28:39 -0400
Message-ID: <>

Indeed, and thanks.

Paul Baumgartel
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
Phone 212.538.1143

-----Original Message-----
From: Wolfgang Breitling [] Sent: Friday, April 04, 2008 3:24 PM
To: Baumgartel, Paul
Cc:; oracle-l
Subject: RE: Same index, different plan

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
>Information Technology
>Prime Services Databases Americas
>One Madison Avenue
>New York, NY 10010
>Phone 212.538.1143


Wolfgang Breitling
Centrex Consulting Corporation

Please access the attached hyperlink for an important electronic communications disclaimer:

Received on Fri Apr 04 2008 - 14:28:39 CDT

Original text of this message