We are trying to insert alot of data into an ORACLE indexed table, and
want to know what the fastest way to do this is. We are attempting to
load 16000 records every 10 seconds, each record containing 6 fields, for a
total of 32 bytes/record.
Right now, to use SQL*Loader without the direct option, this takes us about
50 seconds to do. If we use the DIRECT=TRUE option, it takes about 12-15
seconds. Both of these are on an empty machine. ( unix machine, type unknown )
My questions is, is the DIRECT=TRUE option for SQL*Loader the fastest possible
way to insert data into an ORACLE table? Are there any other faster ways
to do this?
Any possible ways to improve the performance of inserting data, while
maintaining query access would be appreciated.
Thanks for any help that you can provide.
Ron Alldaffer
--
====================================================================
====================================================================
