Forum Discussion

gabriel23's avatar
gabriel23
Frequent Visitor
2 years ago

Vertipaq analyzer - Sizes for different columns

trying to figure out why some of these data sizes are large for some of these columns. 

for example, RegistrationAge has very low cardinality, why would it take up so much space compared to other fields

 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    All of your columns seem to suffer from HASH encoding. The engine couldn't find a better compression algorithm.

    • gabriel23's avatar
      gabriel23
      Frequent Visitor
      2 years ago

      I will see about providing a hint in TabularEditor or creating another surrogate field (not ideal)