Archives of the TeradataForum

Message Posted: Thu, 12 Sep 2002 @ 22:19:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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?.

Mark

	<Prev	Next>		<<First	<Prev	Next>	Last>>