MySQL INDEX

-- * test index with 'and & or' - begin *

-- type: ref
explain
select * from student where name = '' and class_id = '';

-- type: all, extra: using where
explain
select * from student where name = '' or class_id = '';

-- type: ref
explain
select * from student where class_id = '' and name = '';

-- type: all, extra: using where
explain
select * from student where class_id = '' or name = '';

-- * test index with 'and & or' - end *



-- * test index with 'order by' - begin *

-- type: ref
explain
select * from student where name = '' and class_id = '' order by name;

-- type: ref, extra: using index condition & using filesort
explain
select * from student where name = '' and class_id = '' order by class_id;

-- type: ref
explain
select * from student where class_id = '' and name = '' order by name;

-- type: ref, extra: using index condition & using filesort
explain
select * from student where class_id = '' and name = '' order by class_id;

-- * test index with 'order by' - end *



-- * test index with 'group by' - begin *

-- type: ref
explain
select * from student where name = '' and class_id = '' group by name;

-- type: ref, extra: using index condition & using temporary & using filesort
explain
select * from student where name = '' and class_id = '' group by class_id;

-- type: ref
explain
select * from student where class_id = '' and name = '' group by name;

-- type: ref, extra: using index condition & using temporary & using filesort
explain
select * from student where class_id = '' and name = '' group by class_id;

-- * test index with 'group by' - end *



-- * test index with 'group by & order by' - begin *

-- type: ref
explain
select * from student where name = '' and class_id = '' group by name order by name;

-- type: ref
explain
select * from student where name = '' and class_id = '' group by name order by class_id;

-- type: ref, using index condition & using temporary
explain
select * from student where name = '' and class_id = '' group by class_id order by name;

-- type: ref, extra: using index condition & using temporary & using filesort
explain
select * from student where name = '' and class_id = '' group by class_id order by class_id;



-- type: ref
explain
select * from student where class_id = '' and name = '' group by name order by name;

-- type: ref
explain
select * from student where class_id = '' and name = '' group by name order by class_id;

-- type: ref, using index condition & using temporary
explain
select * from student where class_id = '' and name = '' group by class_id order by name;

-- type: ref, extra: using index condition & using temporary & using filesort
explain
select * from student where class_id = '' and name = '' group by class_id order by class_id;

-- * test index with 'group by & order by' - end *
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值