Example: Specifying Block-Level Compression Set to ALWAYS - Teradata Vantage

This example creates a table that is block-level compressed using the zlib compression algorithm with a compression level of 8. (The table t_blc is on the Block File System.)

     CREATE SET TABLE t_blc, NO FALLBACK, NO BEFORE JOURNAL, 
                             NO AFTER JOURNAL, CHECKSUM = DEFAULT,
                             BLOCKCOMPRESSION = ALWAYS 
                             BLOCKCOMPRESSIONALGORITHM=ZLIB 
                             BLOCKCOMPRESSIONLEVEL=8 (
       c1   INTEGER FORMAT '-(10)9' )    
     UNIQUE PRIMARY INDEX (c1)  
     PARTITION BY(RANGE_N(c1 BETWEEN 1 
                             AND   500
                             EACH 5));