16.10 - Achieving Maximum Benefit with COMPRESS - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

Maximum benefit is achieved when the COMPRESS phrase is applied to a column under the following conditions:

  • Enough rows contain a compressible value (for example, null, zero, blank, or constant value) in the compressed field to exceed the break-even point. For details, see “Break-even point for value compression” in Database Design.
  • The shortened row length results in the elimination of one or more data blocks.