mysql in 索引_mysql-IN子句不使用索引

这是表的定义

CREATE TABLE `dt_prdtime` (

`TCompany` varchar(3) NOT NULL DEFAULT '',

`TPerCode` varchar(8) NOT NULL,

`TBegDateTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '??????',

`TQPay` int(1) NOT NULL DEFAULT '2',

`TYear` int(4) NOT NULL,

`TMonth` int(2) NOT NULL,

PRIMARY KEY (`TCompany`,`TPerCode`,`TBegDateTime`),

KEY `TMonth` (`TMonth`) USING BTREE,

KEY `TPerCode` (`TPerCode`,`TYear`,`TMonth`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8

这是数据样本.该表有10000条记录,并且TMonth字段中的值有所不同

+----------+----------+---------------------+-------+-------+--------+

| TCompany | TPerCode | TBegDateTime | TQPay | TYear | TMonth |

+----------+----------+---------------------+-------+-------+--------+

| S10 | 000001 | 2016-01-02 17:33:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-02 07:48:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-03 17:39:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-03 07:30:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-04 17:49:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-04 07:54:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-05 17:50:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-05 07:36:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-06 17:37:00 | 1 | 2016 | 1 |

| S10 | 000001 | 2016-01-06 07:35:00 | 1 | 2016 | 1 |

+----------+----------+---------------------+-------+-------+--------+

通过EXPLAIN,此查询使用TMonth索引：

SELECT * FROM dt_prdtime WHERE TMonth = 5

而这个拒绝使用索引：

SELECT * FROM dt_prdtime WHERE TMonth IN (5,6)

我用另一个简单的表进行了测试,

CREATE TABLE `table1` (

`id` int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

SELECT * FROM table2 WHERE id IN (5,6)

并且使用了该表的索引

有人可以解释吗？ dt_prdtime表有问题吗？