MVC on BYTEINT column

Tools
Enthusiast

MVC on BYTEINT column

Hi 

I am using AtanaSoft for MVC purpose.

I have a table with size 22GB.

When I am running tool to generate MVC values I am observing that flag columns (BYTEINT datatype) are not getting any compression values.

Why so ?

As per my understanding, flag columns has value 0 or 1 and should be good candidate for compression ?

Any comments guys why I am not getting any MVC value for such columns via tool ?

--

Raj

Tags (1)
1 REPLY
Junior Contributor

Re: MVC on BYTEINT column

Hi Raj,

I don't know about the costing algorithm used by Atana, but it's hardlly worth compressing single byte values.

Compressing 8 bits to 1 or 2 does not save a lot of disk space. And in worst case there will be a new Presence Byte inserted in every row to carry those 1 or 2 presence bits resulting in saving 6 bits per row but expanding the row by 1 byte.