Use SQL EXPLAIN to understand when and why indexes are used (or not).

Read more at the source