Can you post the query and the explain? I can think of a number of reasons
why your index might not be being used, but you don't give sufficient
information as to why.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Jay" <no_at_spam.com> wrote in message
news:bn6oks$2igr$1_at_msunews.cl.msu.edu...
> I'm trying to speed up my query which selects only 30 records out of
> 3million records.
> All my conditions are indexed but when I explains it, it says TABLE ACCESS
> FULL.
> I use "between" and, it seemingly, when I reduce range of "between" then
it
> does INDEX RANGE SCAN.
>
> Is there anyway I can force to do INDEX RANGE SCAN?
> Thanks.
> -Jay
>
>
>
>
>
>
Received on Thu Oct 23 2003 - 07:51:35 CDT
