In the recent MariaDB DBA advanced training class the question came up if MariaDB can make use of an index when searching for NULL
values... And to be honest I was not sure any more. So instead of reading boring documentation I did some little tests:
Search for NULL
First I started with a little test data set. Some of you might already know it: