Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Aug 2010 @ 09:04:00 GMT


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


Subj:   Field update running slowly
 
From:   GRAHAM, Paul

Hi All

I use a piece of code to create a matchkey to be used to match against another dataset. Im finding the script takes a very long time to run (3 to 4 hours), even though its only running against 180,000 records. The statement is:

     UPDATE DATABASE.TABLE
     SET MATCHKEY = UPPER(Surname)||UPPER(Address_Line_1)||UPPER(Postcode)
     ;

There is no spool space error (my spool space is 60g). Any ideas why this should be occuring or suggestions of optimisation gratefully received.


Paul Graham



     
  <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