17.10 - Combining Multivalue, Algorithmic, and Block-Level Compression - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

You can combine multivalue compression, algorithmic compression, and block-level compression for the same table to achieve better compression. However, as a general rule you should not use algorithmic compression with block-level compression because of the possibility of a negative performance impact for other workloads.