Identifying and Reclaiming Unused Space
Page 2 of 4

Overview

A Cloudscape table or index (sometimes called a conglomerate) can contain unused space after large amounts of data have been deleted or updated. This happens because, by default, Cloudscape does not return unused space to the operating system. Once a page has been allocated to a table or index, Cloudscape does not automatically return the page to the operating system until the table or index is dropped, even if the space is no longer needed. However, Cloudscape does provide a way to:

  • identify unused space in tables and associated indexes
  • reclaim unused space in tables and associated indexes