MySQL Query Analysis

While reading an article on MySQL Query Optimization, I came across the EXPLAIN keyword. It's a built-in feature of MySQL that allows you to get some information on how a given query is used. This is of great help while optimizing queries to find out whether indexes are applied properly.