A method is disclosed for reorganizing a set of database partitions based
on a ranked set of database partitions. The method includes a step to
determine a fragmentation indicator for each database partition within a
set of database partitions. A step ranks the set of database partitions
according to a rank criteria. The rank criteria includes, at a minimum,
the fragmentation indicator. A step reorganizes a subset of the database
partitions in the ranked set of database partitions. The subset is
selected, at least in part, by a rank order for the ranked set of
database partitions. The subset may be selected such that ranked database
partitions satisfying a reorganization threshold are included in the
subset.