Online Documentation for SQL Manager for DB2
Reorganize Indices
Reorganize Wizard allows you to perform the RUNSTATS operation over your DB2 table indexes.
This operation is used to reorganize all indexes defined on a table by rebuilding the index data into unfragmented, physically contiguous pages.
To run the wizard, select the Services | 
Reorganize indexes main menu item, or right-click a table in the DB Explorer tree and select the Table Services | Reorganize indexes context menu item.
- Setting database name
- Selecting tables
- Setting reorganize options
- Setting runstats options
- Reorganizing indexes
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
No |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |
