9
193 天前
```
mysql> explain SELECT name FROM query_test;
+------+-------------+------------+------+---------------+------+---------+------+--------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+------------+------+---------------+------+---------+------+--------+-------+
| 1 | SIMPLE | query_test | ALL | NULL | NULL | NULL | NULL | 497500 | |
+------+-------------+------------+------+---------------+------+---------+------+--------+-------+
1 row in set (0.02 sec)
mysql> explain SELECT id FROM query_test;
+------+-------------+------------+-------+---------------+---------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+------------+-------+---------------+---------+---------+------+--------+-------------+
| 1 | SIMPLE | query_test | index | NULL | PRIMARY | 4 | NULL | 497500 | Using index |
+------+-------------+------------+-------+---------------+---------+---------+------+--------+-------------+
1 row in set (0.02 sec)
mysql> explain SELECT * FROM query_test;
+------+-------------+------------+------+---------------+------+---------+------+--------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+------------+------+---------------+------+---------+------+--------+-------+
| 1 | SIMPLE | query_test | ALL | NULL | NULL | NULL | NULL | 497500 | |
+------+-------------+------------+------+---------------+------+---------+------+--------+-------+
1 row in set (0.00 sec)
```