Re: Q: SQL Load vs. Embedded SQL (Pro C) for Updating Large Table
Date: 1996/03/17
Message-ID: <fmmXyAABIJTxEw0m_at_ahardy.demon.co.uk>#1/1
In article <4hv3eu$2n9q_at_news-s01.ny.us.ibm.net>, "Peter H. Larsen"
<petlars_at_ibm.net> writes
>>Also remember if there are constraints or indexes on the tables
>>you're loading into, if you disable them before loading the
>>tables, you're load time will decrease.
>
>Yes and no. When using DIRECT PATH, no such things are every executed, as
>the mass part of the RDBMS is not used. The file is read and directly passed
>onto
>the blocks of the RDBMS. Thus, no INSERT commands are ever executed! Even
>when loading 1mil+ records.
>
>
Yes and no?
DIRECT PATH will still need to rebuild indexes after a load.
Andy
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
"Faster than a speeding bullet. More powerful than a locomotive. Able to leap tall buildings in a single bound.
"'Look! Up in the sky!' "'It's a bird!' "'It's a plane!' "'No, it's Superman!'
"Yes, it's Superman, strange visitor from another planet who came to Earth with powers and abilities far beyond those of mortal men.
Superman, who can change the course of mighty rivers; bend steel in his bare hands; and who, disguised as Clark Kent, mild-mannered reporter for a great metropolitan newspaper, fights a never ending battle for Truth, Justice, and The American Way!" Received on Sun Mar 17 1996 - 00:00:00 CET