COMPRESS With No Arguments
Compress nulls only.
Note that if you do not specify COMPRESS, nulls are not automatically compressed.
Multivalue Compression (MVC) Specification
- COMPRESS
- Compress column data using multivalue compression.
- constant
- A set of values to be compressed.
- NULL
- Nulls will be compressed.
Algorithmic Compression (ALC) Specification
- COMPRESS USING
- Compress column data using algorithmic compression.
- DECOMPRESS USING
- Decompress column data that was previously compressed using algorithmic compression.
- dbname
- The name of the database in which the compress or decompress user-defined function (UDF) is stored. If a database name is not specified, the default database used is SYSUDTLIB.
- compress_udf
- The name of the UDF used to compress values in the column.
- decompress_udf
- The name of the UDF used to decompress values in the column.