reorg compact combines the functions of reorg reclaim_space and reorg forwarded_rows. Use reorg compact when:
You do not need to rebuild an entire table (reorg rebuild); however, both row forwarding and unused space from deletions and updates may be affecting performance.
There are a large number of forwarded rows. See “Using reorg compact to remove row forwarding”.
If you specify a partition, only the part of the table that resides on that partition is affected.
See “resume and time options for reorganizing large tables”.
