hard20 pts · first answer countsdata-warehousingsnowflakequery-performance

Fast single-order lookups in Snowflake

A 6 TB Snowflake table is clustered by order_date. Support staff run many queries like WHERE order_id = 'ORD-88123', and each one scans most micro-partitions because order IDs are spread across all dates. What is the most targeted fix?

A.Resize the support warehouse from Medium to 2X-LargeB.Change the clustering key to (order_date, order_id)C.Rely on the result cache, since lookups often repeatD.Enable search optimization on the order_id column

Discussion 0

Join free to post in the discussion.

Fast single-order lookups in Snowflake

Discussion 0

Related questions