MODIFY...TO RECONSTRUCT Statement
The MODIFY...TO RECONSTRUCT statement rewrites all data of a table or database.
Note: MODIFY...TO RECONSTRUCT consumes much time and disk space.
This command has the following format:
MODIFY tablename TO RECONSTRUCT
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.