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: query does not use INDEX RANGE SCAN

Re: query does not use INDEX RANGE SCAN

From: mitt <nospam_at_nospam.at>
Date: Thu, 04 Sep 2003 18:42:57 +0200
Message-ID: <3F576B91.4010703@nospam.at> 





Jay wrote:


> I was wrong again. Sorry.

> It's selecting 500097 out of 2935498

> 




the percentage is high enough for the optimizer to choose a full table 
scan, which is most likely a good decision here;
=>stay with the full table scan; it is probably fast than index range scan;
Received on Thu Sep 04 2003 - 11:42:57 CDT












Original text of this message













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