SQL Loader questions
From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: 2000/04/26
Message-ID: <8e6ra6$lmo_at_netnews.hinet.net>#1/1
Date: 2000/04/26
Message-ID: <8e6ra6$lmo_at_netnews.hinet.net>#1/1
Dear all,
I have some questions about SQL Loader:
1.Do constraints slow down the loading substantially? What's the tradeoff?
2.Do you suggest to reduce or disable constraints to the minimum in a data
warehouse or data mart project? Therefore data loading can be easier.
3.If one of the tables will potentially hold as many as 100 million records
(about 10G bytes) and about 100 thousand records a day. This is quite a big
table, what is the speedest possible way of loading data?
4.How to achieve the result of replacing records that have matching primary
key while appending records that are not?
Thanks in advance.
Dino Received on Wed Apr 26 2000 - 00:00:00 CEST