When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?
When choosing the dimensions for an MDC (Multidimensional Clustering) table, poor space utilization can occur due to low cell density attributable to the low cardinality of the dimensions selected. Low cardinality means that there are fewer unique values compared to high cardinality, leading to many cells being sparsely populated, resulting in significant wasted space. High cardinality dimensions would typically lead to a better distribution of data across cells, thus utilizing space more efficiently.
The good answer is "High Cardinality". Indeed, Columns that are involved in equality or range predicate queries, and especially columns with low cardinalities, show the greatest benefit from clustering dimensions. REFERENCE : https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.partition.doc/doc/c0007238.html