News for hackers. Stuff that matters.
Re:A Tale of Query Optimization by jjluoma on Sunday May 19, 2019 @06:21PM (#19955901)
I find this a little bit funny,

> I was extremely suspicious of the EXISTS optimization, since it changes the logic to exit early.

Does this this mean that if one has found an answer, it is somehow sensible thing not to return the answer right away?

Re:A Tale of Query Optimization by abraae on Sunday May 19, 2019 @06:23PM (#19955916)
With a database, that depends if you want "all the answers" or "any answer". Exists is the latter.