When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
A . A single join node uses more than 50% of the query time
B. Partitions scanned is equal to partitions total
C. An AggregateOperacor node is present
D. The query is spilling to remote storage

View Answer

Answer: D