Re: What index access path does INDEX

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 4 Jan 2007 11:49:47 -0000
Message-ID: <b96dnZlGYbfNdAHYnZ2dnUVZ8turnZ2d@bt.com>

"Spendius" <spendius_at_muchomail.com> wrote in message news:1167908823.841971.158290_at_51g2000cwl.googlegroups.com...
>> However, thinking further about this piece of trace file,
>> it looks to me as if Oracle hasn't see your hint at all.
>> This suggests that there is a syntax error somewhere
>> in your hint.
> I don't think so as the optimizer reacts to my hint, it
> reacts the wrong way but does react anyway: when
> I remove the hint I get an FTS on TABLE_1.
>

True,

I was fooled by the presence of the calculation of the full tablescan - which doesn't appear in any of my attempts to reproduce the problem when I use the hint.

-- 
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

Received on Thu Jan 04 2007 - 05:49:47 CST

Re: What index access path does INDEX_SS yield ?