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 … |
---|---|
COMPRESS with:
|
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. |
COMPRESS with:
|
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. |