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

This example creates a table with its BLOCKCOMPRESSION option set to AUTOTEMP, so that Vantage can change the compressed state of the data in the table at any time based on its temperature. (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 = AUTOTEMP(
       c1   INTEGER FORMAT '-(10)9' )    
     UNIQUE PRIMARY INDEX (c1)  
     PARTITION BY(RANGE_N(c1 BETWEEN 1 
                             AND   500
                             EACH 5));