Bending queries to your will with EXPLAIN

English session

Just about anyone can write a basic SQL query for a table. Not everyone can write a *good* query though - that takes practice and knowing how to understand what the optimizer is doing with the query. Learn the basics of query optimization so you keep your application engaging the user rather then showing the progress bar as they wait on the database.

Sheeri K. Cabral View speaker page

The Pythian Group

Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and produces OurSQL: The MySQL Database Podcast for the Community, by the Community. Keep up with all this at www.technocation.org