Setting Compression for a Session

Enabling or disabling compression for a session does not change the compression level for existing data.

  • Updated rows remain uncompressed. The SAP ASE server uncompresses any compressed rows during the update.

  • If set compression is set to off, commands that require a data copy (for example, reorg rebuild and alter table) uncompress data rows.

  • After you configure set compression on, subsequent updates use the partition or tables’ compression level.