To specify the compression algorithm when you create a table or join index, or alter a table, use the optional BLOCKCOMPRESSIONALGORITHM option. Possible BLOCKCOMPRESSIONALGORITHM values include the following:
DDL Statement BLOCKCOMPRESSIONALGORITHM Keywords | Result |
---|---|
ZLIB | The ZLIB software algorithm is used to compress data blocks. |
ELZS_H | The ELZS_H hardware algorithm is used to compress data blocks on systems configured with a hardware board. |
DEFAULT | The compression algorithm is controlled by system settings. |