Question

An analyst runs a complex aggregation query at 9:00 AM against a large sales table. The query takes 4 minutes on a Medium warehouse. At 9:30 AM the warehouse is auto-suspended due to inactivity. At 9:45 AM a different analyst using the same role runs the exact same query text; no DML has occurred on the underlying table since 9:00 AM. What happens?

Accepted Answer

The result is returned nearly instantly from the result cache, and the warehouse is not resumed because no compute is required.

Answer

The warehouse must auto-resume and re-scan the micro-partitions because the result cache is cleared whenever a warehouse suspends.

Answer

The query reuses the warehouse local disk cache, so it resumes but completes in a few seconds without a full table scan.

Answer

The result cache cannot be used because the second analyst is a different user, forcing a full re-execution.