Slower loading into partitioned table than non-partitioned table - why?
Hi,
Using oracle 11.2.0.3.
Have a large fact table and doing some comparitive tests on loading large amounts of histroical data (several hundred GB) into fact table range partitioned on date.
Whilst I understand if use partition exhange loading can be quicker to load a partitioned table, trying to understand why a standard sql insert takes 3x as long to load a partitioned table as compared to an identical tabel but non-partitioned. Everyhing identical in terms of columsn and the sql doing the insert and running the partitioned sql second to
ensure caching having no impact.
The partitioned table has local partitioned bitmap indexes as compare to the non-partitioned table which has standardnon-partioned bitmap indexes.
Any ideas/thoughts?
Thanks