explain select * from test where score=80
mysql> explain select * from test where score=80 \G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: test
type: ref
possible_keys: score_score2,score
key: score
key_len: 9
ref: const
rows: 27413
Extra: Using where
1 row in set (0.00 sec)
ERROR:
No query specified
推荐文章: mysql explain执行计划详解
官方文档: EXPLAIN Output Format