Which of the below techniques will you be using to decrease remote spilling?

Bytes spilled to remote storage 8.16 GB

Which of the below techniques will you be using to decrease remote spilling?
A . Review the query for optimization, especially if it is a new query
B. Reduce the amount of data processed by trying to improve partition pruning
C. Decrease the number of parallel queries running in the warehouse
D. Try to split the processing into several steps. For example by replacing CTEs with temporary tables
E. Use a larger warehouse
F. Use a multi cluster warehouse

View Answer

Answer: A, B, C, D, E

Explanation

https://community.snowflake.com/s/article/Performance-impact-from-local-and-remote-disk-spilling#:~:text=What%20is%20disk%20spilling%3F,and%20then%20to%20remote%20storage.&text=A%20query%20spilling%20bytes%20to,notice%20even%20further%20performance%20degradation.