Came across this handy cheat sheet for MySQL EXPLAIN:

http://www.beberlei.de/mysql_explain.html

EXPLAIN is a clause in MySQL that explains how a SELECT statement will be executed, and allows one to determine whether the indexing scheme is effective or not.

VN:F [1.9.7_1111]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.7_1111]
Rating: +1 (from 1 vote)
MySQL EXPLAIN Cheat Sheet, 10.0 out of 10 based on 1 rating
Share :
  • Digg
  • del.icio.us
  • Google Bookmarks
  • DZone
  • StumbleUpon
  • Technorati
  • TwitThis

No related posts.