We participate in the Amazon Service LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

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