EXPLAIN EXPLAIN is one of the most powerful tools at your disposal for understanding and optimizing troublesome MySQL queries, but it’s a sad fact that many developers rarely make use of it. In this article you’ll learn what the output of EXPLAIN can be and how to use it to optimize your schema and queries. Understanding EXPLAIN’s Output SELECT queries. Let’s analyze the output of a simple query to familiarize yourself with the columns returned by the command. EXPLAIN SELECT * FROM categoriesG ********************** 1. row ********************** id: 1 select_type: SIMPLE table:
Read full article from Using EXPLAIN to Write Better MySQL Queries
No comments:
Post a Comment