Interesting -- I saw similar results as well with your query.  However, on an example using one of our actual database queries, SQL Server 2022 was much faster (either in...

Interesting -- I saw similar results as well with your query.  However, on an example using one of our actual database queries, SQL Server 2022 was much faster (either in...

One thing we've observed.  Using the RESUMABLE option makes the index significantly longer to create/rebuild.

Here are some tests comparing traditional ONLINE with SORT_IN_TEMPDB on for a CLUSTERED index rebuild.  I'm...