Update query taking forever

[nollieflip]

I have the the following update running and it seems to be running too long. I've let it go 20 minutes and it still hadn't finished. It updates about 45,000 records.

UPDATE BuildAccount
SET EmailAddress1 = (SELECT EmailList.EmailStandard FROM EmailList WHERE BuildAccount.AccountNumber = EmailList.Account + right('0000' + EmailList.Location, 4))

 

[dmhirsch]

Perhaps an inner join would be faster than the subquery, so:
UPDATE BuildAccount
SET EmailAddress1 = EmailList.EmailStandard
FROM BuildAccount INNER JOIN EmailList
ON BuildAccount.AccountNumber = (EmailList.Account + RIGHT('0000' + EmailList.Location, 4))

Also, if you use Query Analyzer on this, what does the execution plan optimizer report?