"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
******************************************
Received on Mon Oct 21 2002 - 10:39:09 CDT
