面试官请不要再问我mysql联合索引失效、有效情况了

版本：5.5.18.1

联合索引建立情况：

查询条件顺序和联合索引一样

EXPLAIN SELECT * FROM t_cmp_mission WHERE companyID = "" AND isFinish ="" AND missionType ="" AND creTm = "";

查询条件顺序和联合索引顺序完全相反

EXPLAIN SELECT * FROM t_cmp_mission WHERE creTm = "" AND missionType ="" AND isFinish =""  AND companyID = "" ;