Skip to content

Mastering PHP and Laravel

Never stop learning!

Menu

  • Home
  • Blog Posts
  • Humor

SQL EXPLAIN: Index-related columns

These relate to the usage of indexes:

  1.  possible_keys
    • Which indexes were considered?
  2. key
    • Which indexes did the optimizer choose?
  3.  key_len
    • How many bytes of the index will be used?
SQL EXPLAIN: Index-related columns
Kenny September 25, 2018September 27, 2023 Blog Posts, Learning, Programming, SQL
  • ← SQL EXPLAIN: The “type” column
  • SQL EXPLAIN: The “ref” column →

Archives

Categories

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