News for hackers. Stuff that matters.
Re:SQL Anti-Patterns You Should Avoid by yxhuvud on Sunday October 19, 2025 @04:06AM (#45632703)
I've seen similar effects when changing a bunch of left outer joins to lateral joins with a limit 1 tacked on. The limit do nothing to the end result, but speed up the query by a factor of 1000..

There are no comments on this comment yet.