Re: TABLE ACCESS FULL

From: Domenic G. <domenicg_at_hotmail.com>
Date: 22 Oct 2003 18:08:09 -0700
Message-ID: <c7e08a19.0310221708.3fba8148@posting.google.com>

select /*+ index(table_name index_name */ rest of your query ...

domenic.

"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 Wed Oct 22 2003 - 20:08:09 CDT