Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Jun 2011 @ 14:15:11 GMT


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


Subj:   Work table during Multi load update and delete
 
From:   Gutta_Ram

HI,

I understand that during ML insert, data is sent in 64k blocks to all amps and then hasing happens and each data row is sent to the actual amp where it is going to reside forever. And in this process, worktable will be used to store data sent by other amps and execution plan of each sql.

Can anyone explain in more elaborative way,how work table will be made use of especially in case of ML update and delete.


Thanks in Advance!!!



     
  <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