Mysql常见索引名词
Mysql常见索引名词
1.回表
select name,age from student where name = ?
(1)非主键索引通过B+,找到主键ID
(2) 主键索引通过B+,找到该行记录
2.覆盖索引
select id from student where name = ?
(1)非主键索引通过B+,找到主键ID
3.最左匹配
select * from student where name = ? and age = ?
(1) 针对组合索引,左边的name可以单独使用索引
4.索引下移
select * from student where name = ? and age = ?
(1)针对组合索引,在innerDB中线找name,并对age筛选,不需要再传递到server端筛选信息