 |
 |
Archives of the TeradataForum
Message Posted: Thu, 24 May 2001 @ 13:11:08 GMT
| Subj: | | Re: Compressing Byte Columns |
| |
| From: | | Geoffrey Rommel |
| | I've got numerous columns defined as byte(10), however the majority of them hold just binary zeroes so I'd like to add a
compress clause in my create table statement. Can anyone advise how to define such a byte constant? | |
You betcha.
my_column byte(10) compress '00000000000000000000'xb
| |