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. 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.
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.
These properties all affect how quickly inserts cause a table to become fragmented, as measured by a low cluster ratio.
Use sp_chgattribute to change the space management settings (see the Reference Manual: Procedures). For reference information about sp_chgattribute, see the Reference Manual: Commands, and for additional detailed information about space management, see Performance and Tuning Series: Physical Database Tuning > Setting Space Management Properties.