Re: Q: SQL Load vs. Embedded SQL (Pro C) for Updating Large Table
From: Peter H. Larsen <petlars_at_ibm.net>
Date: 1996/03/10
Message-ID: <4hv3eu$2n9q_at_news-s01.ny.us.ibm.net>#1/1
Date: 1996/03/10
Message-ID: <4hv3eu$2n9q_at_news-s01.ny.us.ibm.net>#1/1
>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.
Peter H. Larsen Email: Petlars_at_ibm.net Complete Data Service Fidonet: 2:235/134.0
Happy Computing Received on Sun Mar 10 1996 - 00:00:00 CET