Compresses data values and nulls in one or more columns of a table, and decompresses the previously compressed values.
- COMPRESS and DECOMPRESS Syntax
- Number of Columns that Can Be Compressed
- Multivalue Compression (MVC)
- Using MVC with CHARACTER or VARCHAR Data Type
- Rules for Specifying constant Values
- Compress Values of a CHAR or VARCHAR Column in SHOW TABLE
- Achieving Maximum Benefit with COMPRESS
- Algorithmic Compression (ALC)
- Teradata Compression and Decompression Functions
- COMPRESS and DECOMPRESS Restrictions
- COMPRESS and DECOMPRESS Examples
- COMPRESS and DECOMPRESS Related Information
ANSI Compliance
COMPRESS and DECOMPRESS are Teradata extensions to the ANSI SQL:2011 standard.