Reclaim unused index space

You can improve performance by reclaiming unused index space.

The etx indexes do not shrink. Although data that has been deleted is marked as such in the index structure, it is never removed. If you insert and then delete many rows from an indexed table, the index remains at its maximum insertion size even after you delete the rows. To reclaim unused space, you need to drop and recreate the index.