16.10 - Related Topics - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Release Date
June 2017
Content Type
User Guide
Publication ID
English (United States)
Information on... Is available in...
specifying MVC, ALC, or BLC compression in a CREATE TABLE or ALTER TABLE statement SQL Data Definition Language Syntax and Examples
specifying join index row compression in a CREATE JOIN INDEX statement SQL Data Definition Language Syntax and Examples
using the Ferret utility COMPRESS and UNCOMPRESS commands to apply BLC to populated tables Utilities
using the DBS Control utility to set or modify BLC parameters Utilities
using the BlockCompression query band in a SET QUERY BAND statement to override BLC settings SQL Data Definition Language Detailed Topics
applying compression to various data types using the COMPRESS and DECOMPRESS phrases SQL Data Types and Literals
block-level compression use cases and examples Teradata Database Orange Book

541-0008970Block-Level Compression by Carrie Ballinger