针对等值和范围查询,如果有一个索引 (A.B.C)。从索引能效看:哪个写法效能最高?

针对等值和范围查询,如果有一个索引 (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