For a comparison of compression methods that are available, see Compression Types Supported by Vantage .
Join Index Row Compression
When describing compression of join indexes, compression refers to a logical row compression in which multiple sets of non-repeating column values are appended to a single set of repeating column values. This enables the system to store the repeating value set only once, while any non-repeating column values are stored as logical segmental extensions of the base repeating set.
Block-Level Compression
Block-level compression, or BLC, is a lossless physical compression method that can be specified in a CREATE TABLE statement. Block-level compression can be applied to row-level security constraint columns, which are not eligible for multivalue compression and algorithmic compression.
Autocompression for Column-Partitioned Tables
When describing system-selected autocompression of containers in column-partitioned tables, compression refers to compression methods that Vantage can use to compress the column values of a container.