Data Compression

Hardware & Software Components
- Hardware (Microcode) provides 4-5 Times Performance
Compression at Tablespace or Partition Level
Ziv-Lempel Compression Technique
- Favors De-Compression (Read)
- Dictionary within TS or Partition
Compressed Objects up to 255 Rows/Page
Saves DASD, Reduces I/O for Large Scans
May save CPU, May cost CPU