Click here to see the full article post
I don't understand why when I use p1.x < p2.x as the condition, the running time is always longer. I think this one should do less calculations than the one using p1.x != p2.x
@kevinyyh - I do not see that as a case, in fact, it's performing better when I use < . Looks like it depends on your test data since these are full table scans.