"Andy" <andy.spaven_at_eps-hq.co.uk> wrote in message
news:CFb29.257$9R.1282958_at_newsr2.u-net.net...
> Whoops - ignore the , in the hint. It's just a space really :-))
>
> select /*+ index(<table_name_or_alias> <index_name>) */ ....
and do remember to set timing on first. I (like richard) suspect that Oracle
is choosing the correct plan for a selection of all the records in a table
in some order.
--
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 Thu Aug 01 2002 - 14:51:48 CDT
