Manage Table Compression

The compression advisor provides an estimate of the percentage of space you can save by compressing a user table.

Compression reduces database storage space and improves system performance, especially in I/O-bound systems. Queries against compressed data can be performed with fewer I/O operations, because each read from the disk retrieves more data.

Use the database usage properties to identify tables that might benefit from compression. The compression advisor then provides recommendations for which compression attributes to apply, and a compression estimation that is based on an analysis of sampled data. The estimate is then compared to the selected table in an uncompressed state and the table in its current state, which may or may not be compressed.

Compression advisor requires an ASE_COMPRESSION license and the system-wide configuration parameter enable compression to be set to 1.