Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 14:02:56 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Fast Path Insert
From:   Frank O Connor


The fast path insert assumes that the target table is empty and that the DDL is precisely the same for the source and target tables. Then, it moves blocks rather than having to insert rows.

In addition, as the target table is empty, the transient journal is not required as the optimiser knows that the starting position is an empty table. This speeds it up considerably.

Hope this helps


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