Skip to content

Instantly share code, notes, and snippets.

@tistaharahap
Created August 26, 2016 18:44
Show Gist options
  • Save tistaharahap/c34cbdac3fb1f5187a9069e5167e7daf to your computer and use it in GitHub Desktop.
Save tistaharahap/c34cbdac3fb1f5187a9069e5167e7daf to your computer and use it in GitHub Desktop.
MariaDB [fun]> EXPLAIN SELECT * FROM users;
+------+-------------+-------+------+---------------+------+---------+------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+
| 1 | SIMPLE | users | ALL | NULL | NULL | NULL | NULL | 10 | |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment