|
|
Archives of the TeradataForum
Message Posted: Mon, 31 Jan 2011 @ 20:05:12 GMT
Subj: | | Re: Compression on decimal fields |
|
From: | | Tewksbury, Kevin |
No it does not really handle them any differently. If you were to define the column as Field1 DECIMAL(9,3) NOT NULL DEFAULT 0.0 COMPRESS 0.0
and then do a show table you would see...
Field1 DECIMAL(9,3) NOT NULL DEFAULT 0.000 COMPRESS 0.000.
So, in other words, Teradata defaults your values to the field "size".
Kevin R Tewksbury
Sr. Database Administrator
LimitedBrands
| |