Row compression

Row compression uses a dictionary-based compression algorithm to replace recurring strings with shorter symbols within data rows.

There are two types of row compression that you can choose from:
  • Classic row compression.
  • Adaptive compression
Row compression is available with a license for the Db2® Storage Optimization Feature. Depending on the Db2 product edition that you have, this feature might be included, or it might be an option that you order separately.