Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Sep 2009 @ 23:30:34 GMT


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


Subj:   Re: Update of millions of records
 
From:   Curley, David

Victor - Don't know why I was thinking in terms of DELETE, but yeah, the point is the same.

If the fields being updated don't have stats, the comparison would be "update in place" versus "insert to empty table + collect stats + make grants ," not just "update in place" versus "insert to empty table + make grants." (Leaving aside other issues like availability during the update, space limits, etc.)


Dave



     
  <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: 15 Jun 2023