Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Efficiency of sqlldr
The primary difference between options 1 and 2 is the way in which
data "grows" in the tables. Option 1 one table is populated fully at a
time. In option 2 each table grows by 1000 rows at a time.
Does this cause the physical location of the data on the disks to be
different in options 1 and 2 ? If yes, then select queries with joins
on the tables will be more efficient if data was loaded using option
#2 than option #1.
Any opinions are appreciated.
THanks
Nan.
Received on Thu May 20 2004 - 08:29:58 CDT