Reorganize Tables and Table Objects

Reorganize tables, table partitions, indexes, and index partitions to improve performance by reclaiming unused page space, removing row forwarding, or rewriting all table rows to new pages, depending on the option used.

For additional information about reorganization, see Using the reorg Command in the System Administration Guide: Volume 2.

• Reorganizing Tables at the Database Level
  Reorganize a table at the database level to improve performance.
• Reorganizing Tables
  Reorganize one or more tables to improve performance. By default, reorganization reorganizes all indexes within the selected table.
• Reorganizing Table Partitions
  Reorganize a table partition to improve performance.
• Reorganizing Indexes
  Reorganize an index to improve performance.
• Reorganizing Index Partitions
  Reorganize an index partition to improve performance.
• Status Messages
  Reorganizing large amounts of data may take a long time. During reorganization, you can view the status and possible errors.