针对等值和范围查询,如果有一个索引 (A.B.C)。从索引能效看:哪个写法效能最高?
A:where A = ? and B = ? and C > ?
B:where A > ? and B = ? and C = ?
C:where A = ? and B> ? and C> ?
D:where A = ? and B> 7 and C = ?
3 个赞
选 A
1 个赞
正确答案:A
2 个赞
选择A
2 个赞
选择A
1 个赞
正确答案:A
1 个赞
打卡!!
选择A