Video: Analyzing MySQL Queries with EXPLAIN

April 28, 2010
By Jason Gilmore

The MySQL 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.

In less than seven minutes, this video introduces 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`

Tags: MySQL, database, video

0 Comments (click to add your comment)

Comment and Contribute

Free Trial: Quickly Find and Fix Problems in Your Mixed IT Infrastructure
Sponsored by Hitachi

Managing a mixed IT infrastructure is always a challenge. The challenge is compounded for mid-sized companies where you don't have the staff resources of larger firms. A variety of systems and equipment creates a complex infrastructure where finding and solving performance and network glitches is really difficult. Learn how Hitachi IT Operations Analyzer can help.