"UPDATE dbo.tblProduct*

SET Color = 'Black'

WHERE Name = 'ML Mountain Frame-W - Silver, 42';"

I might be missing something but how can you expect a surrogate key to improve performance if you are not referencing it?