Oracle数据库教程 —— mysql语句分析工具explain使用说明.pdfVIP

广州远佳信息科技有限公司 Oracle 数据库教程 —— mysql 语句分析工具explain 使用说明 mysql explain 使用说明 mysql show databases ; ++ | Database | ++ | information_schema | | kksns | | mytest | | mysql | ++ 4 rows in set (0.00 sec) mysql use mytest; Database changed 下面，我们使用一个语句来介绍explain mysql explain - select distinct d.account,a.server_id from tab_appserver_user a - inner join tab_department_parent b on a.key_id = b.parent_id - inner join tab_department_member c on b.department_id = c.department_id and c.state=1 - and c.isdefault=1 inner join tab_user_info d on c.user_id = d.user_id and d.state=1 - where a.type=1 - union - select distinct b.account,a.server_id from tab_appserver_user a - inner join tab_user_info b on a.key_id = b.user_id and b.state=1 - where a.type=0\G ; *************************** 1. row *************************** id: 1 select_type: PRIMARY table: a type: ALL possible_keys: NULL 广州远佳信息科技有限公司 key: NULL key_len: NULL ref: NULL rows: 31 Extra: Using where; Using temporary *************************** 2. row *************************** id: 1 select_type: PRIMARY table: b type: ref possible_keys: uix_deparment_parent_parent_id key: uix_deparment_parent_parent_id key_len: 4 ref: landray_kk_db.a.key_id rows: 6661 Extra : *************************** 3. row *************************** id: 1 select_type: PRIMARY table: c type: ref