Senior Brother's Insights

Oct 8, 2025 · Databases

When Do IS NULL and IS NOT NULL Use Indexes in MySQL? Surprising Findings

This article explores how MySQL decides whether queries with IS NULL or IS NOT NULL predicates can use an index, presenting three concrete examples with varying data sizes and NULL distributions, and explains the underlying storage of NULL values and optimizer cost decisions.