Re: What index access path does INDEX_SS yield ?

"Spendius" <spendius_at_muchomail.com> wrote in message news:1168330632.241005.59010_at_i15g2000cwa.googlegroups.com... Jonathan asked me two questions in our direct communications:
>>Is "TRTP_ID" also a column in the primary key of TF ?
>>
>>I would raise this with Oracle - but for curiosity sake,
>>you might see what happens with
>> TF.TRTP_ID + 0 = tt.trtp_id

His assumption as to TRTP_ID being a member of the PK was right; as to his suggestion to add a pseudo-condition to the join between TF and TT it worked perfectly as it caused the optimizer to eventually comply with my hint instruction...
Here is what I answered him:

> 1/ yes, TRPT_ID is another field of the PK,
> 2/ and if I add the "+ 0" to the 2nd join condition
>   I get my so boundlessly expected SKIP SCAN !

Thanks, and meilleures salutations à tous. Sp

Spendius,

Thanks for posting the closing details.

I'll try to write this up as a page on my blog (better chance of keeping the output readable) some time next week.

It was an interesting little example of how a 10053 can help pin down a bug.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html