Hi, I have a simple update statement like Update tableName Set Col1 = val1, col2 = val2, col3 = val3 where TablePK = Val The table in question has some 25 columns and some 15 foreign keys. When I see the execution plan of the above update statement I find that there is a Clustered index seek for each of the FK's.I'm concerned because each of the branch showed 3% cost which on accumulation is very high. What I dont understand is, when I'm not changing ALL the columns then why are ALL the FK being referred? Is there a way to stop this from happening? Is there a change on SQL Server 2008? I'm using 2005.