To shrink a btree index, use the modify...to merge option. When data is added to a btree table, the index automatically expands. However, a btree index does not shrink when rows are deleted from the btree table.

Modify...to merge affects only the index, and therefore usually runs a good deal faster than the other modify variants. Modify...to merge does not require any temporary disk space to execute.