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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tuning doubts....

Re: tuning doubts....

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Fri, 5 Oct 2007 14:05:28 -0700
Message-ID: <2ead3a60710051405r37f82bf3mcf18443d6735c3b4@mail.gmail.com>


> sequential reads are usually the result index lookups.
> scattered reads are large multiblock reads, think full table scans.

Just one more: Index Fast Full Scan (Index FFS) also uses multi-block I/O.

-- 
John Kanagaraj <><
DB Soft Inc
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 05 2007 - 16:05:28 CDT

Original text of this message

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