FreeLists / oracle-l / Re: Data load ideas

["Ryan" <ryan.gaffuri@xxxxxxx>]

Foreign keys can lead to tremendous slow downs when bulk loading data. I had
to array insert 7 million records into a parent table 2 weeks ago, it took
less than an hour. To then do the same array insert into the child table
took 8 hours.

----- Original Message ----- 
From: "Tim Gorman" <tim@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, May 01, 2004 1:17 PM
Subject: Re: Data load ideas


> Todd,
>
> I'm not arguing against the index-supports for PKs or FKs.  Indexes and
> constraints are two different animals.  I'm merely arguing against the use
> of RI constraints (over the top of the indexes) in a database that is not
> the source-of-record.  Note that it is the constraints, not the indexes,
> that cause problems cited in this thread and in Jonathan Lewis's post on
> EXCHANGE PARTITION on dbazine.com.
>
> The disadvantages of RI constraints in a DW are obvious -- the original
post
> in this thread is one example.  Any mechanism geared for transactions and
> transactional processing (such as RI constraints or triggers) is bound to
> cause difficulties in the bulk-load operations commonly to large DWs.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------