You can compress as many columns as practical for any table. However, compressing a substantial number of values in a table using MVC can contribute to table header overflow.
|IF you specify …||THEN …|
||nulls are compressed for nullable columns.
NULL cannot be specified in a COMPRESS phrase for a column that is declared NOT NULL.
|COMPRESS with a constant||the indicated value is compressed. For nullable columns, nulls are also compressed.|
||nulls and the specified distinct values are compressed for nullable columns. Nulls are compressed for nullable columns regardless of whether NULL appears in the list.
NULL cannot appear in a COMPRESS phrase for a column that is declared NOT NULL.
|COMPRESS USING compress_udf DECOMPRESS USING decompress_udf||nulls are compressed for nullable columns. Non-null column values that are not specified in the value compression list are compressed using the specified compress UDF, and decompressed using the specified decompress UDF.|