索引最左原则:
如果A B C建索引:
查找走索引:
A
A B
A B C
其他不走索引:
比如: B C
B
C
数据库索引详细介绍:
创建索引:1、普通索引:CREATE INDEX indexName ON 表名(列名);
2、唯一索引:CREATE UNIQUE INDEX indexName ON 表名(列名);
删除索引:
DROP INDEX [indexName] ON 表名;
设有如下表:Student
创建索引
1、普通索引:CREATE INDEX Student_ID ON Student(ID );
2、唯一索引:CREATE UNIQUE INDEX Student_ID2 ON Student(ID );
3、组合索引:CREATE UNIQUE INDEX Student_ID3 ON Student(NAME,AGE,PHONE );
组合索引:上面的组合采用最左原则相当于建立了:NAME,AGE,PHONE NAME,AGE NAME
select * from Student where NAME=‘小明 ’ and age =‘12’ 执行索引
SELECT * FROM Student WHERE name like'admin%' 执行索引
select * from Student where age =‘12’ and phone=‘123’ 不执行索引
SELECT * FROM Student WHEREt Name like'%admin' 不执行索引
课参考我的博客园:https://www.cnblogs.com/gangganghao888/articles/9268883.html