Database Designer is creating a design with some non recomended column list encodings types
Hello, I am a bit confused using the Database Designer and the encoding and compression types details described in reference manual:
When Database Designer is run in comprehensive mode for VMartDB database using sample queries in vmart_queries.sql, it creates a design (VMartDesign01_design.sql) with projections using non-recomended column list encoding types for some columns in the following anchor tables:
1- Anchor table "product.customer_dimension":
- Column "customer_type" has been configured automatically using AUTO encoding but this is a low cardinality column with only two values (Individual and Company). Why this column has not been configured to use RLE encoding?
2- Anchor table "store.store_sales_fact":
- Column "product_key" has been configured automatically using RLE encoding but this is a high cardinality column with more than 830 thousand many distinct and unique values. Why this column has not been configured to use DELTAVAL encoding?
Thank you in advance for your clarifications.