Check How Mysql Index Is Used
Join the DZone community and get the full member experience.Join For Free
EXPLAIN SELECT ... WHERE ...Explain will tell you if your index work as you thought. (I forgot to login in the last two snippets)
Opinions expressed by DZone contributors are their own.