单选题

下列哪条语句不会引起mysql的索引失效

Question

A.

select username,count(*) from user group by username having count(*)>1

B.

select * from user order by addtime desc

C.

select * from user where id is not null

D.

select * from user where id=1 or username=’zhangsan’