Myth: NULL values are never stored in indexes

The Oracle documentation (“Oracle Database 11g: The Complete Reference”) states:
“NULL values are not stored in indexes. Therefore, the following query will not use an index; there is no way the index could help to resolve the query:”

select Title
 where CategoryName is null;

Well … Oracle documentation is not always 100 % right. Just read this blog by Charles Hooper:

Post a Comment

Your email is never published nor shared. Required fields are marked *