ADD (column_name ) AUTO COMPRESS - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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. AUTO COMPRESS applies autocompression to the column or column partition. AUTO COMPRESS is the default. 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. 
You cannot modify the autocompression or partition storage for a column partition more than once in the same ALTER TABLE request.


NO AUTO COMPRESS

The column partition containing the column is not autocompressed.