Was this helpful?
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. To shrink a btree index, use the modify... to merge option. 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.
Last modified date: 11/28/2023