There is any difference in performance between the operator IS NULL and the function ISNULL() ?
+1
A:
Looking into the manual, they seem to be synonyms really.
and even if they aren't, I would tend to trust the query optimizer to pick the best solution.
Pekka
2010-08-20 10:51:00
@Pekka: I readed that too, but the ISNULL doc says that SHARES some special behaviors with IS NULL, that scared me.
Wiliam
2010-08-20 10:54:51
@Wiliam good point. Maybe doing a test run is indeed the best way to go!
Pekka
2010-08-20 10:55:20
Huh? In my understanding, "shares special behaviour" just means they're weird, but they're weird in the *same way*.
Amadan
2010-08-25 18:37:17
A:
I would hope that they are exactly the same under the hood, although the best way to verify this would be to put together a simple test to ensure that this is the case.
ninesided
2010-08-20 10:53:15