QuestionQ22

Performance Optimization, Querying & Transformation

The first execution of a query on a virtual warehouse takes longer than the next execution of that same query an hour later.

What causes this behavior?

Explanation

A query that starts on a suspended virtual warehouse must resume the warehouse and warm its local data cache. Once the warehouse is running, a later execution of the same query can read applicable table data from that cache rather than from the underlying tables, improving performance. A warehouse cache is cleared only if the warehouse is suspended again between executions.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!