A Data Engineer is assessing the performance of a query in a development environment.
Based on the Query Profile, which performance-tuning options can the Engineer use?
A full-result ORDER BY can require a large sort operation. Adding LIMIT, when only a subset of sorted rows is needed, can enable Top-K pruning and reduce the amount of data processed. Significant local and remote storage spilling indicates that the sort exceeded available warehouse memory and local storage; a larger virtual warehouse provides more of both and can reduce spilling. Snowflake: Top-K pruning for improved query performance Snowflake: Queries too large to fit in memory
ORDER BY
LIMIT
Community Discussion