Bulk loading partitioned tables slower than heap tables?
- From: amonte <ax.mount@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 23 Jun 2006 13:00:57 +0200
Hi
I was wondering if anyone has experience bulk loading data to partitioned
tables? I have run some tests and running bulk load (insert append) into
partitioned tables is actually 40% more costy. For example to load up a 80
million rows table it takes around 8 minutes whereas with plain heap table
it only takes 5
Test used:
LMT with 16MB uniform size extent
No ASSM
Parallel DML
Parallel Query
Degree 16
Regards
Alex
Other related posts:
