oepke, Kevin M" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Partitoned Table Insert Performance
>Date: Thu, 02 May 2002 09:48:31 -0800
>
>Way back in the days of Oracle 8.0.5 I did
Way back in the days of Oracle 8.0.5 I did some performance testing of bulk
inserts/sqlldr of range partitioned tables v.s. non-partitioned tables. I
don't have the benchmarks on hand, but here's what I found. All tests were
done using the direct path inserts (sqlldr direct=true or /*+ APPEND */)
My last set of test results is a little out of date,
but here's an idea to check.
Inserting single rows:
partitioned key insert HAD ca. 50% overhead
Array Inserts sorted by partition key to get lots
of adjacent rows in the same partition
virtually no overhead
Array inserts randomised t