Archive

Archive for September, 2010

MySQL Explain – Reference

September 7th, 2010 3 comments

The EXPLAIN command in MySQL is an essential diagnostic tool for any database developer. With it you can learn the details of how the server processes any query and therefore where to spend your time optimizing the query and/or the server indexes. It should be the first thing you check when facing a slow query.

Read more…
Categories: MySQL Tags: