Post reply

Rebuild Indexes

  • November 5, 2015 at 2:19 am

    #322358

    Hi,

    If I rebuild some indexes that are above 30% of average fragmentation, should I after that update spatistics?

    Also, How can I see if I Need to update statistics^on the tables of my database?

  • November 5, 2015 at 2:54 am

    #1837895

    Rebuilding an index also rebuilds that indexes statistics.

    I would recommend getting copies of Ola Hallengren's index maintenance and statistics script and seeing how he calculates what statistics needs updating.

  • November 5, 2015 at 6:35 am

    #1837952

    river1 (11/5/2015)

    Hi,

    If I rebuild some indexes that are above 30% of average fragmentation, should I after that update spatistics?

    Also, How can I see if I Need to update statistics^on the tables of my database?

    Rebuilding an index makes a FULL update of the statistics, so there is no need of doing unnecessary work.

    Reorganizing an index doesn't update the statistics, so you'll have to update the stats after it.

    Igor Micev,My blog: www.igormicev.com

  • November 5, 2015 at 6:52 am

    #1837957

    thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply