大飞_dafei

导航

mysql explain 执行计划详解

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

posted on 2019-01-06 20:39  大飞_dafei  阅读(95)  评论(0编辑  收藏  举报