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/14/2024