16.10 - Example: Compression Using MVC on an INTEGER Column - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

The following example uses MVC to compress a list of numeric values in an INTEGER column.

   CREATE TABLE ID
      (IDNum INTEGER,
       Post  INTEGER COMPRESS (44, 45, 63));