Re: Don't rely on 9i Skip Scan Indexing

Sorry,

I have to correct the correction here.
My notes listing and explaining all the
hints has it as index_ss_ascending,
but in fact it really is

    index_ss_asc
    index_ss_desc

The syntax is the usual index-type

    hint( table_alias {index_name(s)})
format. (Which I didn't mention in the
original post.)

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

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





Jonathan Lewis wrote in message ...


>

>Sorry,

>

>I think I missed this post -

>I got the hint wrong - it is

>    index_ss_ascending

>with the alternative being

>    index_ss_descending

>

>And it isn't in the documentation, and

>as Connor pointed out, I always do a "strings -a"

>on the binary then search for a well-known and

>obvious hint  (like star_transformation) in the

>resulting 10 MB heap of garbage.

>

>--

>Regards

>

>Jonathan Lewis

>http://www.jlcomp.demon.co.uk

>

>Next Seminar dates:

>(see http://www.jlcomp.demon.co.uk/seminar.html )

>

>____USA__________November 7/9   (Detroit)

>____USA__________November 19/21 (Dallas)

>____England______November 12/14

>

>The Co-operative Oracle Users' FAQ

>http://www.jlcomp.demon.co.uk/faq/ind_faq.html

>

>

>

>

>

>Niall Litchfield wrote in message

><3db41f9e$0$8506$ed9e5944_at_reading.news.pipex.net>...

>>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message

>>news:ap0amv$4cp$1$8300dec7_at_news.demon.co.uk...

>>> Rule one when 'feature does not work'  is

>>> to hint it in to find out what the cost of

>>> making it work is going to be.

>>>

>>> Try  /*+ index_ss_asc */ with the query

>>> and you may find that a skip scan on

>>> your data set has a cost which is higher

>>> than the FTS..

>>