|
|
|
| Table
Compression: |
||
| What isnt 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 |
|||||||||||||||