This section describes data compression options that you can use to reduce disk space usage and possibly improve I/O performance.
- Multivalue compression (MVC)
- Algorithmic compression (ALC)
- Row compression
- Row header compression
- Autocompression
- Join index row compression
- Block-level compression (BLC) (For Object File System tables, BLOCKCOMPRESSION has a default value that you cannot change.)
The following content is mainly applicable to the standard nodes of the primary cluster in VantageCloud Lake and may not apply to compute clusters on the primary cluster.
For information about the primary cluster and compute clusters, see Managing Compute Resources.
- Compression Types Supported by Vantage
- Identifying Uncompressed, Single-Value Compressed, and MultiValue Compressed Tables
- Multivalue Compression
- Tradeoffs between Multivalue Compression and Storage Requirements for Compressed Values
- Algorithmic Compression
- Row Compression
- Row Header Compression
- Autocompression
- Using Join Index Row Compression
- Block-Level Compression
- Software-Based Block-Level Compression
- Block-Level Compression Usage Notes
- CPU Considerations on Different Teradata Platforms
- Getting Information about Tables with Compressed Data Blocks
- System and AMP Outages during Compression
- Choosing a Software-Based Compression Scheme
- Combining Compression Methods