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: Efficiency of sqlldr

Re: Efficiency of sqlldr

From: Nan <nandagopalj_at_hotmail.com>
Date: 20 May 2004 05:32:04 -0700
Message-ID: <8193246.0405200432.48da0c57@posting.google.com> 





So is the performance of "select queries" is not dependant on the way
in which the table is populated with data ? I was thinking that the
data will be organized differently on the physical disk with option 1
and option 2. With option #2 the data pertaining to a batch is
co-located and is faster to seek hence delivering faster response
times.  Any opinions ?



Thanks


Nan.
Received on Thu May 20 2004 - 07:32:04 CDT












Original text of this message













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