Add autocompression for the column partition. You can add compression to a set of existing columns whether or not the table is empty or contains data. You can only specify autocompression for column-partitioned tables. You cannot modify the autocompression or partition storage for a column partition more than once in the same ALTER TABLE request.
- AUTO COMPRESS
- Applies autocompression to the column or column partition. AUTO COMPRESS is the default. The system applies autocompression for a physical row on a per container basis. For efficiency, the system may use the autocompression method chosen for the previous container, including not using autocompression, if that is more effective.
- NO AUTO COMPRESS
- The column partition containing the column is not autocompressed.