Post reply

Rebuild the indexes in chuncks

  • April 7, 2011 at 3:33 pm

    #236367

    Is it possible to rebuild the indexes in bunch of them at a time like finding the most used indexes and rebuilding only them ?

  • April 7, 2011 at 3:41 pm

    #1308866

    AK1516 (4/7/2011)

    Is it possible to rebuild the indexes in bunch of them at a time like finding the most used indexes and rebuilding only them ?

    Yes. If you are looking for a good high quality script to help with that - try the Defrag script by Michelle Ufford.

    http://sqlfool.com/2010/04/index-defrag-script-v4-0/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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