15.10 - ADD (column_name ) AUTO COMPRESS - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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


The AutoCompressDefault cost profile constant can be set to change the autocompression default. For more information about the AutoCompressDefault cost profile constant, see SQL Request and Transaction Processing, B035-1142.
For more information about temporal column attributes, see Temporal Table Support, B035-1182.

NO AUTO COMPRESS

The column partition containing the column is not autocompressed.