Determining How Much Table Header Space is Used for Compression
The following procedure is an easy way to determine how much table header space is used for a particular set of column multi-value compressions.
1 Create two unpopulated tables that are identical except that one is defined with compression and the other without.
2 Perform the following query against both empty tables.
WHERE TableName = ’table_name’;
where table_name is the name of the compressed or uncompressed table.
3 Perform the following calculation.
The result is the space in bytes used for multi-value compression in the table header.