Archives of the TeradataForum
Message Posted: Fri, 03 Feb 2012 @ 20:57:26 GMT
Not quite. You're correct in that there is always 1 presence byte in the row header of which only 7 bits are available for use.
However, remember that the presence bits are used to indicate both NULL values and compressed values. So, if your table definition includes only NOT NULL columns and there are no compressed columns then those 7 bits are available.
In that situation, if you added up to 128 (2 ^ 7 = 128) MVC values for a ** single ** column then you shouldn't need any further presence bytes. So you can actually compress more than 7 values in the single column and not use more bytes.
I think that as soon as you start compressing more than one column then you'll find that you cannot fit so many MVC values into the same number of bytes.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|