To define a compressed table, use the compression specification (COMPRESSED) in the column definition in the CREATE TABLE definition SQL statement. If necessary, also specify a split compression size. Note that the following conditions apply to the compression specification:
- A compression specification can only be specified for columns (it cannot be specified for tables).
- A compression specification can only be specified for columns of the following data types:
- BINARY type whose definition length is 256 bytes or greater
- Abstract data type (XML type)#
- #
- To compress data in a column with the abstract data type (XML type), HiRDB XML Extension version 09-03 or later is required.