mysql explain 執行計劃詳解

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