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 and associated wait

Index Fast Full Scan and associated wait

From: EscVector <Junk_at_webthere.com>
Date: 11 Jan 2007 08:10:40 -0800
Message-ID: <1168531840.130757.22890@77g2000hsv.googlegroups.com> 





I'm bottlenecked on db file sequential read.  What wait should I expect
to see if the plan shows Index Fast Full Scan?  Is it db file
sequential read or scattered read since the Fast Full Scan is treated
like a tablescan  and uses multiblock reads?
Received on Thu Jan 11 2007 - 10:10:40 CST












Original text of this message













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