6. QUEL and EQUEL Statements : Modify Statement--Change Table or Index Properties : Modify...to Merge Option
 
Share this page                  
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.