Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Performance improvement following a disable indexes, shrink, enable indexes - but why? RE: Performance improvement following a disable indexes, shrink, enable indexes - but why?

  • February 12, 2018 at 7:51 pm

    #1979552

    Jeff Moden - Monday, February 12, 2018 5:54 PM

    That's not quite what she's saying.  She's was explaining that you disabling the indexes and then re-enabling them caused an index rebuild, which also causes a stats update with a full scan as a result.  It IS a good thing to use OLA's stuff to do your STATS updates on a regular basis whether or not an index needs defragmenting or not.

    Jeff, my bad explanation.
    Prior to starting down this path we used Ola's scripts, but they indicated that there was nothing for us to do.
    I'm aware that rebuilding the indexes will update the stats, but missed the fact that I should have have tried updating the stats as a first option. Sometimes you lose sight of the obvious.
    I'm hoping that I can encourage the client to implement the index optimise code as part of their loading process.
    pcd
    PS Waiting to get you the info on the tables etc requested in a prior post.