Archives of the TeradataForum
Message Posted: Thu, 24 May 2012 @ 12:48:56 GMT
| Subj: || || Re: Space occupied by blanks |
| From: || || Newell, Ray |
It depends of you have presence bits available. If you do not have to acquire another presence byte, then compressing a byte, especially on a
large table with say hundreds of rows, could save a significant amount of space. A lot of times trading a bit for a byte on vary large tables can
be a good tradeoff. You can look at the tables current nullable and compressible columns and determine if you have available bits within the
current presence bytes.