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.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)
MySQL EXPLAIN Cheat Sheet, 10.0 out of 10 based on 1 rating  
Be Sociable, Share!
  • Tweet

Related posts:

  1. SQL Server 2005 Cheat Sheet …
  2. SQL Server-Related Cheat Sheets That Can Save You Time …
  3. Indispensible MySQL Resources …
  4. Transfer data from MySQL to SQL Server Using SSIS …
  5. Generating Random Data for SQL Server and MySQL …
  6. How to increase an InnoDB log file size …

Yarpp