56,678
社区成员
发帖
与我相关
我的任务
分享
mysql> explain select * from T_Alarm_Information where recover_Date>'2013-06-03 09:57:00' and creat_Date<'2013-06-03 11:57:00';
+----+-------------+---------------------+------+------------------------+------+---------+------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------------+------+------------------------+------+---------+------+----------+-------------+
| 1 | SIMPLE | T_Alarm_Information | ALL | i_t_alarm_info_rectime | NULL | NULL | NULL | 15647542 | Using where |
+----+-------------+---------------------+------+------------------------+------+---------+------+----------+-------------+
1 row in set (0.00 sec)
| t_alarm_information | 1 | i_t_alarm_info_rectime | 1 | CREAT_DATE | A | 205888 | NULL | NULL | | BTREE | |
| t_alarm_information | 1 | i_t_alarm_info_rectime | 2 | RECOVER_DATE | A | 340163 | NULL | NULL | YES | BTREE