索引失效的十大杂症
基于Mysql8.0版本
1、查询条件包含or,可能导致索引失效
create table s1
(
id int auto_increment
primary key,
age int not null,
name varchar(255) not null
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
create index idx_age
on s1 (age);
INSERT INTO s1 (id, age, name) VALUES (1, 1, '1');
INSERT INTO s1 (id, age, name) VALUES (2, 2, '2');
INSERT INTO s1 (id, age, name) VALUES (3, 3, '3');
INSERT INTO s1 (id, age, name) VALUES (4, 4, '4');
INSERT INTO s1 (id, age, name) VALUES (5, 5, '5');
INSERT INTO s1 (id, age, name) VALUES (6, 6, '6');
INSERT INTO s1 (id, age, name) VALUES (7, 7, '7');
INSERT INTO s1 (id, age, name) VALUES (8, 8, '8');
INSERT INTO s1 (i