Finding Tables and Databases with Compressed Data Blocks - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Finding Tables and Databases with Compressed Data Blocks

To find tables that use BLC, issue the Ferret command SHOWCOMPRESS. The command lists the names of tables with compressed BLC data blocks, whether they were compressed manually or automatically with temperature-based compression.