Block-Level Compression and Tables | CREATE TABLE | Teradata Vantage - Block-Level Compression and Tables - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

Tables can be block compressed, depending on the DBS Control compression settings or whether the tables have been compressed or decompressed using the Ferret utility. For information about the DBS Control and Ferret utilities and how the block compression settings interact with other DBS Control file system settings, see Teradata Vantage™ - Database Utilities, B035-1102.

Limits on data block sizes apply to the noncompressed size of a table. Block compression does not raise any of these limits, nor does it enable more data to be stored in a single data block than can be stored in an noncompressed data block of the same size.

Whether volatile table and global temporary tables are compressed or not depends on whether the Optimizer caches the relation in the request cache. See Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142. If a relation is cached, it is not compressed. If the relation is not cached, it is compressed.