Question

A financial reporting dashboard runs the exact same aggregation query every morning at 8:00 AM. Analyst A runs the query first and the result completes in 45 seconds. Two minutes later, Analyst B (using a different role but with SELECT privileges on the same tables) runs the identical query text. The underlying tables have not changed. Analyst B's query returns in under one second and the Query Profile shows a single QUERY RESULT REUSE node. Which condition MOST directly explains why Analyst B could reuse Analyst A's cached result?

Accepted Answer

The result cache is available across users as long as the requesting role has the necessary privileges on the queried objects and the query text is identical

Answer

The result cache is scoped per-user, so it only worked because both analysts share the same warehouse

Answer

The warehouse local disk (data) cache was reused because the warehouse stayed running between the two queries

Answer

The metadata cache served the aggregation result directly from micro-partition min/max statistics