When reorg rebuild rebuilds a table, it rewrites all table and index rows according to the table’s current settings for reservepagegap, fillfactor, and exp_row_size. These properties all affect how quickly inserts cause a table to become fragmented, as measured by a low cluster ratio.
If it appears that a table quickly becomes fragmented and must be rebuilt too frequently, you may need to change the table’s space management settings before you run reorg rebuild.
To change the space management settings, use sp_chgattribute (see the Reference Manual). For information on space management settings, see Chapter 3, “Setting Space Management Properties” in the Performance and Tuning Series: Physical Database Tuning.
