Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.
It’s not that the query got slower, it’s that the results that came back were
Now, this can totally happen because of a bug in previously used logic, but that’s somewhat rare.
wrongdifferent results make testers nervous. Especially in production.
This is where knowledge of abstract math and logic (like De Morgan’s Laws, both of which I’ve used to tune queries in the past because I’m a nerd) can pay off