Reorganizing table data

If the data for a table is reorganized, it may be easier to access. The following conditions may indicate that a table should be reorganized using the reorg command:

• If many rows of a table have been updated, deleted, or inserted
• If runstats, has been run and performance has still not improved
• If an appropriate index is available, but the access plan shows that it is not being used
• If running the reorgchk command indicates that a reorganization should be done (for example, if an index that was previously being used now has a low cluster ratio).

After reorganizing a table, it is recommended to use the runstats command to provide the optimizer with current statistics. Then rebind your application.

You can use the Control Center to run the reorg and runstats commands.

For more information, see the section on considerations for reorganizing table data in the Administration Guide.

For information about the reorg and reorgchk commands, see the section for each of these commands in the Command Reference.