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.