RE: Same index, different plan

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
  • Date: Fri, 4 Apr 2008 15:28:39 -0400

Indeed, and thanks.

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com


-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw@xxxxxxxxxxxxx] 
Sent: Friday, April 04, 2008 3:24 PM
To: Baumgartel, Paul
Cc: mark.powell@xxxxxxx; 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
>CREDIT SUISSE
>Information Technology
>Prime Services Databases Americas
>One Madison Avenue
>New York, NY 10010
>USA
>Phone 212.538.1143
>paul.baumgartel@xxxxxxxxxxxxxxxxx
>www.credit-suisse.com
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 



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

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2008