How does clustering depth affect query performance?
Low clustering depth means that micro-partitions have little overlap, so the table is better clustered for the relevant columns. This allows Snowflake to prune unnecessary micro-partitions more efficiently during queries.
Community Discussion