Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: Bulk loading partitioned tables slower than heap tables?

Enrique Fernandez-Pampillon

2006-06-23

Replies:

Hi,
 
When you load data into a partitioned table oracle has to check every record to decide in which partition store it.
 
When you load data in a heap table oracle hasn't to check it. All records are saved in the same segment.
 
But .... have you test how long it takes to finish some queries in both cases?
 
You can save time when you load in partitioned tables using partition clause.
 
HTH

 
On 6/23/06, amonte <ax.mount@gmail.com> wrote:
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

 



--
------------------------------------------------
Enrique
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.