TechPlanetScaleabout 3 years ago
Why isn't MySQL using my index?
16 min read
MySQL's query optimizer may skip an index if the query uses functions on indexed columns, leading to full table scans. The optimizer also ignores indexes when the query selects a large percentage of rows, as a full scan becomes cheaper. Using EXPLAIN reveals which indexes are considered and chosen.
Level
Hype check
Tap to vote and see what everyone thinks.