17.10 - Autocompression - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval

When you create a column-partitioned table, Vantage compresses the data that you insert into the physical table rows unless you specify the NO AUTO COMPRESS option for the table or for specific column partitions.

Unless you specify NO AUTO COMPRESS, Vantage does the following for column partitions with the COLUMN format:
  • Considers the cost of decompressing the data and determines whether autocompression is worthwhile
  • Selects a compression method
  • Automatically compresses values and decompresses them when you need to retrieve them

Autocompression is most effective for a column partition with a single column and COLUMN format.

Vantage determines whether to apply both autocompression and user-specified multivalue and algorithmic compression to a column, and if the user-specified methods do not help to compress a container, the system only applies autocompression.