17.10 - Achieving Maximum Benefit with COMPRESS - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
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 Teradata Vantage™ - Database Design, B035-1094.
  • The shortened row length results in the elimination of one or more data blocks.