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:30 pm

    #1972219

    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.

    The question I have is why does it matter?  Presumably you're going to update both columns regardless, so does it really matter which one will perform better?

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA