Home Forums SQL Server 2005 Administering Rebuilding indexes RE: Rebuilding indexes
BU69
SSCrazy
Points: 2784
More actions
May 11, 2009 at 3:38 am
#991970
For an online index rebuild it means that all the tables will not be locked, for offline the tables would be locked so if you want your database to be available for the duration of your index rebuilds then the best option is to use online.