QuestionQ30Verified/Performance Optimization, Querying & TransformationCopy linkReport a problemAsk AstroTutorSave questionWhen do queries benefit from clustering?Choose twoAWhen queries filter or sort on the clustering keyBWhen queries use the SELECT DISTINCT command to remove duplicate rowsCWhen queries use random sampling to explore the data setDWhen queries use the ORDER BY or GROUP BY parameter on the clustering keyEWhen clustering keys are applied to columns that are not used in filters or joinsShow AnswerAnswerExplanationSnowflake clustering benefits queries that filter or sort on the clustering key. Sorting commonly occurs for ORDER BY and GROUP BY operations, so using either on the clustering key can benefit from clustering.Learn moreSnowflake Documentation — Clustering Keys & Clustered TablesShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion