Question
Scaling up vs. scaling out: what does each add, and when should each be used?
Answer
Scaling up increases resources within each cluster, helping an individual resource-heavy query. Scaling out adds clusters, helping independent concurrent queries. Scale up for spills or long scans; scale out for sustained queueing from concurrency.