views:

47

answers:

2

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
@Pekka: I readed that too, but the ISNULL doc says that SHARES some special behaviors with IS NULL, that scared me.
Wiliam
@Wiliam good point. Maybe doing a test run is indeed the best way to go!
Pekka
Huh? In my understanding, "shares special behaviour" just means they're weird, but they're weird in the *same way*.
Amadan
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