ALTER TABLE `test`
ADD INDEX `test_index`(`name`,`sex`,`address`) USING BTREE;
select * from test where sex = '1' and address = 'test' ; -- 不生效
select * from test where address = 'test' -- 不生效
select * from test where name = 'test' and sex = '1' and address = 'test'; -- 生效 ()
索引失效1.创建了单字段索引,where条件内多个字段ALTER TABLE `test` ADD INDEX `test_index`(`name`) USING BTREE;select * from test where name = 'test' and sex = 02.创建联合索引,where条件单个字段ALTER TABLE `test` ADD INDEX `test_index`(`name`,`sex`) USING BTREE;select * from test