Reclaming Space Without the reorg Command

SAP ASE includes a number of activities that reclaim or reorganize space in a table on a page-by-page basis.

Each of these has limitations and may be insufficient for use on a large number of pages. For example, inserts may execute more slowly when they need to reclaim space, and may not affect many pages with space that can be reorganized. Space reclamation under the housekeeper garbage collection task compacts unused space, but a single housekeeper garbage collection task that runs at user priority may not reach every page that needs it.