Question
Micro-partitions versus user-defined partitions: what differs, and when should administrators intervene?
Answer
Micro-partitions are automatic contiguous, columnar storage units created from load order. User-defined partitions are not an administrative construct for standard Snowflake tables. Intervene with clustering or search optimization when measured pruning is inadequate for a large, important workload.