SQL EXPLAIN: The “type” column

September 25, 2018 by Kenny

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

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