17.10 - AUTO COMPRESS - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

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