Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TABLE ACCESS FULL

Re: TABLE ACCESS FULL

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Wed, 22 Oct 2003 20:28:50 GMT
Message-ID: <6MBlb.31352$i92.20685@clgrps13>


Jay wrote:

> 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
>

post your oracle version and query. Also, what are optimizer_index_caching and optimizer_index_cost_adj set to? Have you analyzed the relevant tables/indexes? Received on Wed Oct 22 2003 - 15:28:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US