15.00 - Combining Multi-Value, Algorithmic, and Block-Level Compression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Combining Multi-Value, Algorithmic, and Block‑Level Compression

You can combine multi-value compression, algorithmic compression, and block‑level compression for the same table to achieve better compression, but 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.