Why not make an online index rebuild resumable?
0
votes
1
answer
103
views
[The documentation](https://learn.microsoft.com/en-us/sql/relational-databases/indexes/guidelines-for-online-index-operations?view=sql-server-ver16#resumable-index-considerations) makes resumable index rebuilds sound like magic. For example, it claims
> Generally, there's no performance difference between resumable and nonresumable online index rebuild.
and
> Resumable index create or rebuild doesn't require you to keep open a long running transaction, allowing log truncation during this operation and a better log space management.
Personally, I've [had them save the day once before](https://dba.stackexchange.com/a/344483/277982) .
So, assuming:
- SQL Server 2022
- Enterprise Edition
- I have already decided to do my index maintenance online
Why would I ever decide to rebuild an index without making said rebuild resumable?
Asked by J. Mini
(1237 rep)
Jan 1, 2025, 03:05 PM
Last activity: Jan 2, 2025, 02:50 PM
Last activity: Jan 2, 2025, 02:50 PM