SQL EXPLAIN: The “type” column

The “type” column indicates how MySQL will access rows
From worse to better:

  • ALL
  • index
  • range
  • ref
  • eq_ref
  • const
  • system
  • NULL