Online Documentation for SQL Manager for DB2
Run Statistics
Runstats Wizard allows you to perform the RUNSTATS operation over your DB2 tables.
This operation is used to update statistics about the physical characteristics of a table and the associated indexes. These characteristics include the number of records, number of pages and the average record length. It is recommended to run the operation when a table has had many updates, or after reorganizing a table.
To run the wizard, select the Services | 
Run Statistics main menu item, or right-click a table in the DB Explorer tree and select the Table Services | Run Statistics context menu item.
|
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: |
