-
Hello johnsher,
That’s a great question. While Short Query Acceleration (SQA) does improve responsiveness for short queries, it doesn’t actually solve the core issue in your scenario: the long-running query still takes over two hours and continues consuming cluster resources, which means other queries can still be affected when demand is high. SQA simply prioritizes short queries but doesn’t remove the underlying workload contention.
By contrast, Concurrency Scaling with a dedicated WLM queue isolates the heavy query and automatically adds extra cluster capacity only when it’s needed. Accordingly, you receive one free hour of Concurrency Scaling usage per day per cluster, and beyond that you’re charged per-second while the additional cluster is active. This model is often more cost-effective than permanently resizing the cluster, since you only pay for the bursts, and it ensures both long and short queries run without blocking each other.
If you have further questions or need additional clarification, please don’t hesitate to contact us.
Best,
Irene @ Tutorials Dojo
