1

MySQL Conference Liveblogging: EXPLAIN Demystified (Tuesday 2:00PM)


Posted by Artem Russakovskii on April 15th, 2008 in Databases

  • Baron Schwartz presents
  • only works for SELECTs
  • nobody dares admit if they've never seen EXPLAIN
  • MySQL actually executes the query
  • at each JOIN, instead of executing the query, it fills the EXPLAIN result set
  • everything is a JOIN (even SELECT 1)
  • Columns in EXPLAIN
  • id: which SELECT the row belongs to
  • select_type
  • simple
  • subquery
  • derived
  • union
  • union result
  • table: the table accessed or its alias
  • type: