Deletes - and compression of data files

In the good old days of SE, a table with a high level of activity (i.e. deletions/inserts) became riddled with old data row slots which were available for re-write, and the index began to look like swiss cheese. To correct this periodic unload/loads or cluster manipulation or ALTER TABLE (same as an unload/load but more user-friendly) were needed to keep index and data table efficiency at peak. Is this also true of Online? Or does Online do this automagically? j. _____________________________________________________________________________ Jack Parker - Contractor | Hewlett Packard, BSMC Boise, Idaho, USA| These don't look like opinions. jparker@hpbs2651.boi.hp.com | Are you sure they're mine? (208) 323-5388 (W) (208) 384-1623 (H) | _____________________________________________________________________________