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.
Use sp_chgattribute to change the space management settings (see the Reference Manual). For reference information about sp_chgattribute, see the Reference Manual: Commands, and for additional detailed information about space management, see Chapter 3, “Setting Space Management Properties” in the Performance and Tuning Series: Physical Database Tuning.
