Sample MaxL command to query the Compression Estimation Statistics:
query database 'ASOsamp'.'Sample' list aggregate_storage compression_info;
Principles:
. The candidate for compression dimension should not have too many "Stored level 0 members".
. Average bundle fill:is the average number of values stored in the groups. It is between 1 to 16. 16 is the best, 1 is the worst. For the candidate dimension, it should have the greatest value compared to other dimensions.
. Expected level 0 size: This field indicates the estimated size of the compressed database. A smaller expected level 0 size indicates that choosing this dimension is expected to enable better compression.
