Archives of the TeradataForum
Message Posted: Thu, 12 Sep 2002 @ 22:19:04 GMT
The nullability presence bit is only present for nullable columns and is there whether they are compressed or not.
In Tony's case, you are right, the 15 non-null columns being compressed will cause 15 additional presence bits, and the odds are that this works out to 2 additional presence bytes. (Unless there just happened to be 7 bits available in the existing lastmost presence byte).
So the question is: are there 27 billion rows in the table?
If not, just on a lark, did you check that there is not a typo on the default string or the compress string so that they don't match?.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|