Skip to content

Mastering PHP and Laravel

Never stop learning!

Menu

  • Home
  • Blog Posts
  • Humor

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
SQL EXPLAIN: The “type” column
Kenny September 25, 2018September 27, 2023 Blog Posts, Learning, Programming, SQL
  • ← A faster alternative to correlated sub-queries
  • SQL EXPLAIN: Index-related columns →

Archives

Categories

Copyright © 2025 Mastering PHP and Laravel. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.