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 needs to be rebuilt too frequently, it may be a sign that you 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 the Performance and Tuning Guide.
