ALTER INDEX [myIndex] ON [dbo].[myTable] REORGANIZE WITH ( LOB_COMPACTION = ON )
I have the above query running for 16 days (still running), the table is a dummy table used for benchmark tests, it has over 10 Billion rows. (About 1 TB of data including
I know there is progress as when I query for fragmentation, I see the number decrease.
If I cancel / stop the execution of the
ALTER INDEX, can I resume it later safely, or will it cause to a rollback?
Will it rollback roll just the last page swapped or the whole operation ?