17.10 - Interaction between Block-Level Compression Settings - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
Language
English (United States)
The order of precedence between coexisting block-level compression settings is the following:
  • The DBS Control utility setting applies when there are no other settings.
  • The query band setting overrides the DBS Control utility setting.
  • The table-level setting overrides everything else.