Database Administrator Guide > Database Administrator Guide > Maintaining Storage Structures > Modify Procedures > Shrinking a B-tree Index > Before
Was this helpful?
Before
         <=16                     >16
        /                             \
     <=8      >8              <=24    >24
      /        \               /        \
<=4  >4    <=12  >12     <=20  >20    <=28  >28

Page 1     Page 2       Page 3       Page 4
(deleted   (deleted     valid        valid
 data)      data)       data         data
To re-balance the index level, you can use the Shrink B-tree Index option. It also reclaims unused leaf pages that otherwise are never reused. This is shown in the following "After" diagram:
Last modified date: 08/28/2024