As the DBA, have you ever had to cancel an online rebuild or create index process on a very large table? Perhaps it didn’t finish during your maintenance window or consumed valuable resources, causing other queries to run slowly? It is a headache for all database administrators to manage massive index operations.
The worst part about canceling the rebuild or index creation process was that the entire process was reversed and all previous work was lost. It would be preferable if you could resume at the point where your canceled online rebuild or create index statement left off, rather than