Home Forums SQL Server 2005 Administering Will shrinking the DB improve time taken by index rebuild process ? RE: Will shrinking the DB improve time taken by index rebuild process ?

  • June 17, 2013 at 3:47 am

    #1624511

    Joy Smith San (6/17/2013)

    What are thr things that we need to do to speed up the index rebuild process ?..... in brief...

    Better IO subsystem.

    More memory (maybe)

    Reduce the need to rebuild indexes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass