Archives of the TeradataForum

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

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

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>>