Help needed with EXPLAIN and EXPLAIN EXTENDED examples

I am working on a presentation for the San Francisco MySQL Users Group on using EXPLAIN and EXPLAIN EXTENDED. But I need some help from the MySQL Community. Do you have any good examples of EXPLAIN EXTENDED providing unexpected results when compared to the original query? Please post your statement and possibly a SHOW CREATE TABLE below or send them to david.stokes AT Oracle.


Published by


Dave Stokes is a MySQL Community Manager for Oracle and previously was the MySQL Certification Manager for MySQL AB and Sun Microsystems. He has a MBA from the University Of San Diego.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s