Re: What index access path does INDEX_SS yield ?

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:ReGdnda80ec0SAHYnZ2dnUVZ8turnZ2d_at_bt.com...
>
> I can't reproduce the case of
> index_ss(alias index_name)
> becoming a full tablescan.
>
>

My earlier comment should have been

    I can't reproduce the case of

        index_ss(alias index_name)
    becoming a __index full scan__.

rather than the

    becoming a full tablescan.
that I typed.

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