 |
 |
Archives of the TeradataForum
Message Posted: Tue, 02 Oct 2007 @ 22:03:23 GMT
| Subj: | | Re: Float data type compressions |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Tue, 2 Oct 2007 16:46:14 -->
There may be a few values you can compress (zero, NULL, default if not zero or NULL). Other than that, FLOAT data type is generally a poor
candidate for value compression - especially if the field contains calculated results. The external decimal formatted value may not exactly match
the bit pattern stored - no matter how many significant digits you try to enter.
| |
