Question

A data engineer reviews the Query Profile for a slow-running aggregation query on a Medium warehouse. The profile shows a large value for 'Bytes spilled to local storage' but zero for 'Bytes spilled to remote storage'. The query completes, but the engineer wants to understand what this indicates and how to improve performance. Which statement BEST describes the situation and the most appropriate remediation?

Accepted Answer

Intermediate results exceeded available memory and spilled to the warehouse's local SSD; increasing the warehouse size provides more memory and local storage, which can reduce or eliminate the spillage.

Answer

The query is scanning too many micro-partitions; adding a clustering key on the aggregation columns will eliminate the local spillage entirely.

Answer

Local spillage means the result cache was bypassed; re-running the identical query will serve results from cache and avoid all spillage.

Answer

Local spillage indicates network congestion between compute and storage layers; enabling the Query Acceleration Service will offload the spilled bytes.