15.00 - Adding, Modifying, or Dropping Block-Level Compression - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Adding, Modifying, or Dropping Block-Level Compression

You cannot add, modify, or drop the block-level compression characteristics of a table or join index using ALTER TABLE requests. You must use the Ferret utility (see Utilities: Volume 1 (A-K)) to change the block-level compression of a table or join index. See “Block‑Level Compression and Tables” on page 509 for a brief description of the restrictions on specifying block-level compression for volatile and global temporary tables.