O'Reilly logo
  • Ravi Yadlapalli thinks this is interesting:

NULL values pose several difficulties for SQL statements. Indexed columns that have rows containing a NULL value do not have an entry in the index (except for bitmapped indexes—which is why bitmap indexes are usually fast for NULL searches). Under normal circumstances, the following statement would cause a full table scan to be performed, even if the SAL column is indexed: