Table Compression:
What isn’t it?
•This is not a generic ‘zip’-style compression
–Not all tables will have good compression
–Compression algorithm guarantees that compression will never increase size of table
–Most large DW tables seem to compress well
•Compression happens between column/row values, not within column/row values
–Long character strings are not compressed unless the exact same string appear multiple times
•LOB/BLOB columns are not compressed