17.00 - Example: Adding a New Column With Multivalue Compression - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

The following ALTER TABLE request adds a new compressible column and specifies the maximum number of distinct values for compression.

     ALTER TABLE mkw.x ADD b CHARACTER(2) 
       COMPRESS (
        'a1','a2','a3','a4','a5','a6','a7','a8','a9','a10',
        'b1','b2','b3','b4','b5','b6','b7','b8','b9','b10',
        'c1','c2','c3','c4','c5','c6','c7','c8','c9','c10',
        'd1','d2','d3','d4','d5','d6','d7','d8','d9','d10',
        'e1','e2','e3','e4','e5','e6','e7','e8','e9','e10',
        'f1','f2','f3','f4','f5','f6','f7','f8','f9','f10',
        'g1','g2','g3','g4','g5','g6','g7','g8','g9','g10',
        ‘h1','h2','h3','h4','h5','h6','h7','h8','h9','h10',
        'i1','i2','i3','i4','i5','i6','i7','i8','i9','i10',
        'j1','j2','j3','j4','j5','j6','j7','j8','j9','j10',
        'k1','k2','k3','k4','k5','k6','k7','k8','k9','k10',
        'l1','l2','l3','l4','l5','l6','l7','l8','l9','l10',
        'm1','m2','m3','m4','m5','m6','m7','m8','m9','m10',
        'n1','n2','n3','n4','n5','n6','n7','n8','n9','n10',
        'o1','o2','o3','o4','o5','o6','o7','o8','o9','o10',
        'p1','p2','p3','p4','p5','p6','p7','p8','p9','p10',
        'q1','q2','q3','q4','q5','q6','q7','q8','q9','q10',
        'r1','r2','r3','r4','r5','r6','r7','r8','r9','r10',
        's1','s2','s3','s4','s5','s6','s7','s8','s9','s10',
        't1','t2','t3','t4','t5','t6','t7','t8','t9','t10',
        'u1','u2','u3','u4','u5','u6','u7','u8','u9','u10',
        'v1','v2','v3','v4','v5','v6','v7','v8','v9','v10',
        'w1','w2','w3','w4','w5','w6','w7','w8','w9','w10',
        'x1','x2','x3','x4','x5','x6','x7','x8','x9','x10',
        'y1','y2','y3','y4','y5','y6','y7','y8','y9','y10',
        'z1','z2','z3','z4','z5');