理解MySQL索引与优化

mysql explain select actor_id from actor order by actor_id \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: actor type: index possible_keys: NULL key: PRIMARY key_len: 4 ref: NULL rows: 4 E

mysql> explain select actor_id from actor order by actor_id \g

*************************** 1. row ***************************

           id: 1

 select_type: SIMPLE

        table: actor

         type: index

possible_keys: NULL

PHPEIP

PhpEIP企业信息化平台主要解决企业各类信息的集成，能把各种应用系统(如内容管理系统，网上商城，论坛系统等)统一到企业信息化平台中，整个系统采用简单易用的模板引擎，可自定义XML标签，系统采用开放式模块开发，符合开发接口的模块可完全嵌入到平台;内容管理模块可自定义内容模型，系统自带普通文章模型和图片集模型，用户可以定义丰富的栏目构建企业门户，全站可生成静态页面，提供良好的搜索引擎优化;会员管理模

0

查看详情

          key: PRIMARY

      key_len: 4

          ref: NULL

         rows: 4

        Extra: Using index

1 row in set (0.00 sec)

mysql> explain select actor_id from actor order by password \G

*************************** 1. row ***************************

           id: 1

 select_type: SIMPLE

        table: actor

         type: ALL

possible_keys: NULL

          key: NULL

      key_len: NULL

          ref: NULL

         rows: 4

        Extra: Using filesort

1 row in set (0.00 sec)

mysql> explain select actor_id from actor order by name \G

*************************** 1. row ***************************

           id: 1

 select_type: SIMPLE

        table: actor

         type: index

possible_keys: NULL

          key: name

      key_len: 18

          ref: NULL

         rows: 4

        Extra: Using index

1 row in set (0.00 sec)