下面哪种场景不能用到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


Tag:索引 场景 时间:2022-12-09 15:45:36