Home Forums SQL Server 2008 T-SQL (SS2K8) 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 ? RE: 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 ?

  • December 14, 2017 at 1:24 pm

    #1972217

    koustav_1982 - Thursday, December 14, 2017 12:53 PM

    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.

    Are you updating the 10 million rows?
    If the update is only to a few rows, the performance shouldn't be much different, but I suggest that you still test.
    One thing that might affect and it's more probable in a wider table is the presence of multiple indexes that contain the updated column.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2