QuestionQ18Verified/Performance Optimization, Querying & TransformationCopy linkReport a problemAsk AstroTutorSave questionHow does clustering depth affect query performance?ALow clustering depth indicates that there are a large number of overlapping micro-partitions and that the query pruning is efficient.BHigh clustering depth indicates that queries are taking advantage of caching and that the queries are running efficiently.CLow clustering depth indicates that there are few overlapping micro-partitions and that the query pruning is efficient.DHigh clustering depth indicates that too many users are scanning the same micro-partitions, slowing down query performance.Show AnswerAnswerExplanationLow 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.Learn moreMicro-partitions & Data Clustering | Snowflake DocumentationSYSTEM$CLUSTERING_DEPTH | Snowflake DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion