Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 30 Mar 2011 @ 22:08:32 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: TD13: Value compression on Timestamp columns
From:   Hohman, Bruce

You can use multi-value compression on VARCHAR data types in 13.10

Here's and excerpt from the TD 13.10 SQL Data Types and Literals manual:

You can use MVC to compress columns with the following data types:

* Any numeric data type

To compress a DATE value, you must specify the value as a Date literal using the ANSI DATE format (DATE 'YYYY-MM-DD').

For example: COMPRESS (DATE '2000-06-15').


The TD 13.10 Database Design manual now says that null is not compressed as a default when you add compress to a column, you have to specify it.

Looks like I need to do some reading and re-evaluate how I think about compression,


Bruce Hohman
Teradata Corporation
Certified Teradata Master V2R5

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023