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 ?
george sibbald
SSC Guru
Points: 104210
More actions
June 11, 2013 at 3:48 am
#1622791
plus the shrink will cause heavy fragmentation so there will be more for the rebuild\reorg to do.
---------------------------------------------------------------------