Answer: Cluster the underlying table being queried.

The question asks how to improve long-running query performance in Snowflake. Option B (Cluster the underlying table being queried) is the correct answer because clustering tables in Snowflake organizes data based on clustering keys, which significantly improves query performance by reducing the amount of data scanned, especially for large tables where queries filter on specific columns. This is a fundamental performance optimization technique in Snowflake. The community discussion shows 100% consensus on B with upvoted comments supporting this choice. Option A (Reduce virtual warehouse size) would likely degrade performance by reducing compute resources. Option C (Disable result cache) would not help with initial query execution and might hurt performance for repeated queries. Option D (Add ORDER BY) could actually increase execution time for sorting operations rather than improving performance.

Author: LeetQuiz Editorial Team