MODIFY...TO RECONSTRUCT Examples
Apply updates to the sales_dimen table by rewriting the entire table:
MODIFY sales_dimen TO RECONSTRUCT
Note: To conserve time and disk space, consider using MODIFY...TO COMBINE instead, which typically does not rewrite the entire table.