FIX: Rebuilding an Index with Resumable Online Index Rebuild can result in a fragmented index in SQL Server 2017

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


Assume that you rebuild an index with Resumable Online Index Rebuild (ROIR) by using the RESUMABLE = ON option in an instance of SQL Server 2017. When the rebuild is completed, you may notice that the newly built index is fragmented.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

      Cumulative Update 12 for SQL Server 2017

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
 

References


Learn about the terminology that Microsoft uses to describe software updates.