SnowPro Advanced Data Engineer

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