Optimize storage

You can optimize storage by compressing data, configuring the server to add more storage space automatically, and defragmenting partitions. Compressing data reduces the amount of disk space needed for your applications.

Use SQL administration API commands to:
  • Compress data in table or fragment row and simple large objects in dbspaces, consolidate the remaining free space, and return the free space to the dbspace.
  • Compress only row data or only simple large objects in dbspaces.
  • Compress detached B-tree indexes, consolidate free space in the index, and return the free space to the dbspace. You can also compress indexes when you use create them with the CREATE INDEX statement.
  • Implement automatic space management
  • Defragment partitions to non-contiguous extents
  • Compress data in table or fragment rows
  • Consolidate the free space that remains in the table or fragment
  • Return the free space to the dbspace.
  • Implement automatic space management
  • Defragment partitions to non-contiguous extents