MODIFY...TO RECONSTRUCT Statement
The MODIFY...TO RECONSTRUCT statement rewrites all data of a table or database. It can optionally repartition a table or remove partitioning from a table.
This command has the following format:
MODIFY tablename TO RECONSTRUCT [WITH PARTITION=dimension | NOPARTITION]
where dimension is that described in
Partitioning Syntax. For example:
MODIFY tablename TO RECONSTRUCT WITH PARTITION=(HASH ON column 2 PARTITIONS)
Note: MODIFY...TO RECONSTRUCT consumes much time and disk space.
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.
Last modified date: 11/09/2022