Use optdiag to check the cluster ratio and the number of forwarded rows in tables. Declines in cluster ratios may also indicate that you can improve performance by running reorg commands:
If the data page cluster ratio for a clustered index is low, run reorg rebuild or drop and recreate the clustered index.
If the index page cluster ratio is low, drop and recreate the nonclustered index.
To reduce the frequency with which you run reorg commands to maintain cluster ratios, increase the reservepagegap slightly before running reorg rebuild.
See Chapter 2, “Statistics Tables and Displaying Statistics with optdiag,” in Performance and Tuning Series: Improving Performance with Statistical Analysis.
