Skip to content

Instantly share code, notes, and snippets.

@tistaharahap

tistaharahap/explain-index.sql

Created August 27, 2016 11:31
Show Gist options
  • Save tistaharahap/2f34b1a08f7215515b4728f220759a9a to your computer and use it in GitHub Desktop.
Save tistaharahap/2f34b1a08f7215515b4728f220759a9a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain-index.sql
MariaDB [fun]> EXPLAIN SELECT * FROM users WHERE last_name = 'Harahap';
+------+-------------+-------+------+---------------+------------+---------+-------+------+-----------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+------+---------------+------------+---------+-------+------+-----------------------+
| 1 | SIMPLE | users | ref | last_names | last_names | 53 | const | 2 | Using index condition |
+------+-------------+-------+------+---------------+------------+---------+-------+------+-----------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment