Alex Rivera | Logout

Differences between "IS NULL" and "ISNULL()" in Mysql

Asked 2010-08-20T10:44:26.227
24

Is there any difference in performance between the operator IS NULL and the function ISNULL()?

Edit
Report

1 Answer

17

This thread is similar, though not exactly on MySQL. According to the test shown there:

IS NULL is more efficient as it doesn't require a scan.

Seek is generally faster than a scan as it only includes qualifying records, while scan includes every row. It is explained in more detail here.

Another difference (though it's not performance) is their negation syntax:

IS NOT NULL  /* using NOT operator */
! ISNULL()  /* using exclamation mark */
answered 2013-07-09T18:20:35.923

Your Answer