For as long as I’ve been at Microsoft, we have attempted to put our heart and soul into one of the best query processors (QPs) in the industry. But as I saw in technical support for so many years, there were some scenarios where the QP struggled. Back in 2016, our team started a journey to make the query processor adaptable to a variety of workloads, helping users achieve consistent or improved performance with no code changes.
We first called this effort Adaptive Query Processing (AQP). I first heard of this ...
