Achieving Maximum Benefit with COMPRESS - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K
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 Teradata Vantage™ - Database Design, B035-1094.
  • The shortened row length results in the elimination of one or more data blocks.