http://www.developer.com/db/article.php/3879206/Video-Analyzing-MySQL-Queries-with-EXPLAIN.htm
The MySQL In less than seven minutes, this video introduces
Video: Analyzing MySQL Queries with EXPLAIN
April 28, 2010
EXPLAIN statement enables you to gain insight into MySQL's query execution plan, valuable information for creating the most efficient table structures and queries. When working with large amounts of data, you'll need to actively monitor and optimize queries in order to always ensure satisfactory performance.EXPLAIN by walking you through two scenarios that demonstrate how you can use this robust feature to boost your MySQL database performance.
Watch the full video at Internet.com/video:
Analyzing MySQL Queries with EXPLAIN