16.10 - Example: Compression Using MVC with a Multi-valued List - 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 date values in a DATE column.

   CREATE TABLE Duration
      (DurationID INTEGER,
       StartDate  DATE COMPRESS (DATE '2000-01-01',
                                 DATE '2000-01-02',
                                 DATE '2000-01-03'));