4. SQL Statements : MODIFY : MODIFY...TO RECONSTRUCT Statement : MODIFY...TO RECONSTRUCT Examples
 
Share this page                  
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.