Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Choose two.)
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Choose two.)
In the context of a Query Profile, if intermediate results do not fit in memory, they are typically spilled to storage. The statistics that indicate this situation are 'Bytes spilled to local storage' and 'Bytes spilled to remote storage'. These metrics directly show that the intermediate results have exceeded the available memory and have been temporarily stored elsewhere.
https://docs.snowflake.com/en/user-guide/ui-query-profile
correct