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: 11/09/2022