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.