Column compression

Database
Enthusiast

Column compression

I Have a table with say 100 columns of which Iam compressing 40 columns. Let us say, i have 255 compressible values for each compressed column.Suppose I have around 10 billion rows in the table.

Now I want to know whether the column compression works correctly.I would like to check whether all the values in a certain column of the table which are also included in compressible values list of that column are compressed correctly.I would like to identify those values which I think should be compressed but are not actually compressed either due to mismatch in representation in compression list.Is there any easy way to Identify what values are actually compressed.