Post reply

Diff index rebuild time.

  • June 24, 2013 at 1:14 am

    #274473

    Hello All,

    I have an index rebuild job which always used to take around 5 hours. Last week it took only 3 hours. Can anyone guide what all I need to check to identify why it took only 3 hours last time ?

    Thanks in advance,

    Smith.

  • June 24, 2013 at 3:39 am

    #1626701

    There are factors like Database load, resource availability at that time of Index rebuilding.

    Can you post the index size, what options you are using to rebuild like online/offline, sort_in_tempd etc?

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

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