When the majority of column values are unique, algorithmic compression can provide better compression results than multivalue compression. Multivalue compression can coexist with algorithmic compression, so you can use an IF-ELSE construct to compress values using a compression algorithm from a dictionary or a custom compression algorithm.
Algorithmic compression has significant overhead each time the compressed column is accessed during the running of a query, and is therefore best for columns used only for the final projected answer set.