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 3:02 pm

    #1979535

    GilaMonster - Monday, February 12, 2018 2:13 AM

    Dropping and creating an index results in updated statistics (with FULLSCAN). that's the most common reason why index rebuilds improve performance.

    We tests Ola Hallengren's code against the database - nothing was found, everything check out OK.
    I'll give the update statistics with full scan a go.

    pcd