Interaction between Block-Level Compression and TVS Temperature Query Band Values - Teradata Vantage - Analytics Database

Database Design

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ogg1628096130566.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zqc1472244571611
lifecycle
lifecycle
Product Category
Teradata Vantageā„¢
If you set both TVSTEMPERATURE and BLOCKCOMPRESSION values for a query band, unless the table setting for BLOCKCOMPRESSION is NEVER, the result is:
  • BLOCKCOMPRESSION determines the compression if the table setting is MANUAL.
  • TVSTEMPERATURE determines the compression if the table setting is AUTOTEMP.

If the setting for BLOCKCOMPRESSION is ALWAYS, the table is always compressed.