EXPLAIN is one of the most powerful tools at your understanding and optimizing troublesome MySQL queries. However, many developers rarely make use of it. In this blog post, I would like to share what the output of
EXPLAIN can be and how to use it to optimize your schema and queries.
Continue reading “[MySQL] EXPLAIN the Queries”