The change I made yesterday speeds up the slow query in question theoretically (uses an index that filters more rows), but slows everything down because it reads more pages into memory => consumes more memory => more disk swaps => more CPU.