Offline vs Online index operation

• RaufDBA

  Old Hand

  Points: 369

  More actions

  December 24, 2019 at 10:28 am

  #3710205

  As I know, while online index rebuilding, SQL Server virtually creates an index and then at the end it swaps the existing old index with the new created one and then finally drops the old index. I would like to know if these operation same for offline index rebuild. Will SQL Server create virtually an index and then swap it with the existing one?

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  December 25, 2019 at 11:10 am

  #3710320

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.