Was this helpful?
After
           <= 24          >24
           /                  \
         <=16   >16      <=28   >28
  
         Page 3         Page 4
         valid          valid
         data           data

     Free page list: 1,2
The index is rebuilt, and empty leaf pages are marked as free, but otherwise leaf and data pages remain untouched. Therefore, this procedure is neither as time-consuming nor as disk-space intensive as modifying the table structure using the Change Storage Structure option. Shrink B-tree Index, however, does not re-sort the data on the data pages. Modifying the structure to B-tree is the only option for resorting data on data pages.
Last modified date: 01/30/2023