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 -> Index Fast Full Scan vs Index Full Scan?

Index Fast Full Scan vs Index Full Scan?

From: <sweidanz_at_yahoo.com>
Date: Mon, 15 Oct 2001 20:34:32 +1000
Message-ID: <qbJy7.5$mL2.511@nsw.nnrp.telstra.net> 





I dont totally understand whats the difference between these two access 
methods? I know they both access the index only to get the requested 
records because all the columns specified in the query including the 
predicate clause exist in the index. But the thing that i dont understand 
is the differences and why the index fast full scan does not return the 
data sorted?



Thanks,ZS
Received on Mon Oct 15 2001 - 05:34:32 CDT












Original text of this message













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