16.20 - 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
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

A specified set of distinct values in a column that is to be compressed to zero space.

See Teradata Vantage™ - Database Design, B035-1094 for a detailed description of multivalue compression.

See Teradata Vantage™ Data Types and Literals, B035-1143 for more information about the COMPRESS attribute.

NULL
Specifies that nulls are compressed.
You can only specify NULL once per column.
constant
Specifies that nulls and the value are compressed.
Compressed constants are typically string literal. For numeric columns, constants have a numeric data type.
The most space a numeric value can occupy is eight bytes.
Using COMPRESS on fixed-length character data can save space depending on the percentage of rows for which the compressed value is assigned.
See Teradata Vantage™ Data Types and Literals, B035-1143 for information about limits for this value.