Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Sunday, December 17, 2017

Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

SQLServerCentral » Latest topics
Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?
I have a table with 4 columns and 10 million rows in which I want to update 1 column
I have another table with 100 columns and 10 million rows in which again, I want to update 1 column.

Which one among these 2 would perform better.

No comments: