To assess the need for running reorg, use statistics from the systabstats table and the optdiag utility. systabstats contains statistics on the utilization of table space, while optdiag generates reports based on statistics in both systabstats and the sysstatistics table.
For information on the systabstats table, see the Performance and Tuning Guide. For information about optdiag, see Utility Programs for UNIX Platforms.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
