Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Apr 2002 @ 13:35:00 GMT


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


Subj:   Re: Are updates generally slow in Teradata
 
From:   Satish Umale

Well, as said & experinced too, updates are very costly on teradata. The turn around would be to use the intermidiate table then use Insert-Select and drop them when finished.

For example in the senario you mentioned I would create a tables, one insert the records the records to be updated with new values. Second step insert the remaining records. Third step drop the old table and rename the intermidiate table to old table.

This is much much faster when update is more than 20% of your data in the table.



     
  <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