Archives of the TeradataForum
Message Posted: Wed, 04 Aug 2010 @ 09:04:00 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|