Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.htmlReceived on Tue Jan 09 2007 - 02:28:00 CST