Diff index rebuild time.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  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.

• SQL Show

  SSCertifiable

  Points: 6143

  More actions

  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?