目录
一、创建数据表
CREATE TABLE test (
id INT PRIMARY NOT NULL AUTO_INCREMENT,
a1 CHAR(10),
a2 CHAR(10),
a3 CHAR(10),
a4 CHAR(10),
a5 CHAR(10),
);
二、向数据表中插入字段
INSERT INTO test(a1,a2,a3,a4,a5)VALUES('a1','a2','a3','a4','a5');
INSERT INTO test(a1,a2,a3,a4,a5)VALUES('b1','b2','b3','b4','b5');
INSERT INTO test(a1,a2,a3,a4,a5)VALUES('c1','c2','c3','c4','c5');
INSERT INTO test(a1,a2,a3,a4,a5)VALUES('d1','d2','d3','d4','d5');
三、创建联合索引在a1,a2,a3,a4字段上
CREATE INDEX idx_test_a1234 ON test(a1,a2,a3,a4);
四、索引案例分析
1、字符串未使用引号,导致索引失效
select * from test where a1 = a1;
select * from test where a1 = 'a1';
2、符合索引最左原则使用不当,导致索引失效
select * from test where a1 = 'a1' and a2 = 'a2' and a3 = 'a3' and a4 = 'a4';
se