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

Niall Litchfield wrote:
>
> "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..
>
> Incidentally I did try this hint, but presumably got the syntax wrong, so I
> went to the 9i docs at tahiti. Unfortunately this hint doesn't seem to
> appear where I'd expect it (in the access paths hints section for
> performance tuning.), or in a search. Did you find it elsewhere or is it
> time for a documentation bug.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************

If you've got a unix then run 'strings' on the oracle binary, and all the hints are typically bunched up together. The next challenge is then guessing how they meant to work syntactically...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."