WHERE some_field = NULL

[jamesd]

I was working through a query log earlier and came across some 5% of the queries doing something like this

Comments

[codetoad]

It's the whole value versus reference thing. "is null" is much better because it has nothing to do with the value but rather the reference.

is that sort of thing really a bottleneck, though?