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

Kumaran

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

Frank



     
  <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: 27 Dec 2016