22-25 April 2026 
Denis Reznik
Ukrainian Database geek and SQL community enthusiast.
Video unavailable
SQLBits 2022
Why my query is slow and how to fix this
What is the primary root cause of the query slowness? The answer to this question will lead as to the options to tune it. This session will give a straightforward approach to finding the answer and query optimization based on it.
Generally, there are only two options for query slowness: either the query itself is slow (high CPU time), or the query is waiting for some resource (high Wait time). All other reasons for query slowness come from these two options. In this session, we will learn how to determine the reason for the long-running query, what the request can wait for, and how to make the query faster.