16.20 - AUTO COMPRESS - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

You can only specify this option for columns or column partitions of a column-partitioned table. Teradata Database 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.

AUTO COMPRESS
Apply auto compression to values inserted into this column partition.
NO AUTO COMPRESS
Do not apply auto compression to values inserted into this column partition.