The following output is returned by SYSTEM$CLUSTERING_INFORMATION() for a table named ORDERS that has a DATE column named O_ORDERDATE:
SYSTEM$CLUSTERING_INFORMATION()
ORDERS
DATE
O_ORDERDATE
What does the total_constant_partition_count value indicate about this table?
total_constant_partition_count
total_constant_partition_count is the count of micro-partitions whose specified clustering-column values have reached a constant state, meaning reclustering would not significantly improve them. A value of 493 therefore indicates that 493 micro-partitions are already effectively clustered on O_ORDERDATE for this purpose.
Community Discussion