Tag: indexing
All the articles with the tag "indexing".
You created an index and the query is still slow. Here's why MySQL ignores it.
EXPLAIN says type: ALL and key: NULL even though the index exists. Four common reasons an index you just built gets skipped, and how to confirm which one you hit.