When do queries benefit from clustering?
Snowflake 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.
ORDER BY
GROUP BY
Community Discussion