The fastest way to rebuild indexes RRS feed

  • Question

  • We have over 5 Tb database. There are some indexes more then 15 Gb in size.

    The total rebuild of all indexes which are fragmented more then 30% takes about 1 day to perform.

    It takes about 7 minutes to rebuild one index of 26 Gb in size. Is this ok?

    We tried to make several jobs to go in parallel, but it makes no help.

    What is the fastest possible way to rebuild indexes?

    Wednesday, June 17, 2015 1:49 PM


All replies