Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 29 May 2001 @ 19:49:26 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Multiload to multiple tables
From:   Michael Larkins

Hi Klas:

Although I have no data to support my observations, here are my thoughts:

1. Having one DML and one APPLY statement means - Less Host resources to sequence incoming records (values for 5 extra sequencing columns for restart can be seen in the Error table 1)

2. Having one APPLY means - Less Host resources to "branch" to DML logic in the second DML statement

Over millions of rows, this extra processing time can add up. Remember, it has nothing to do with the time to complete Teradata's processing time. It is entirely on the Host computer that is running the MLOAD.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023