下面哪种场景不能用到Index索引?
下面哪种场景不能用到Index索引?
A.Select * from customer where customer()id=10;
B.Select * from customer where customer()name LIKE ‘SMIT%’;
C.Select * from customer where customer()id =4 OR customer()id =7 OR customer()id =10;
D.Select * from customer Where LEFT(last()name,4)=’SMIT’;
正确答案:D