MySQL有一个复合索引：INDEX(`a`, `b`, `c`)，以下查询能用上索引的有？ 多选题

• B、select * from users where b = 2 and a = 1

test

• 编辑

CodePeasant 950

6年前回答

• B、select * from users where b = 2 and a = 1

• 编辑

aoxiangque 3

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

lmz李 24

6年前回答

• A、select * from users where a = 1 and b = 2
• D、select * from users where b = 2 and c = 1

• 编辑

tteee 270

6年前回答

• A、select * from users where a = 1 and b = 2
• D、select * from users where b = 2 and c = 1

• 编辑

leiyuxiao 1

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

我要去面试 42

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1
• D、select * from users where b = 2 and c = 1

• 编辑

wufei 72

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1

最左侧匹配原则，

1. a,b,c
2. a,b
3. a,c 只用到a 按顺序，不能有运算，函数，表达式，且like只能是前缀匹配，order 多字段排序，需要升降级一致

• 编辑

aftersun 3313

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1
• D、select * from users where b = 2 and c = 1

• 编辑

fuqisngs 18

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

杨威利de红茶 11

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1
• D、select * from users where b = 2 and c = 1

• 编辑

ithuan 1

6年前回答

• A、select * from users where a = 1 and b = 2
• C、select * from users where a = 2 and c = 1

• 编辑

flame.stzhang 16

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

最左前缀匹配

• 编辑

Bailiff 12

6年前回答

• A、select * from users where a = 1 and b = 2
• D、select * from users where b = 2 and c = 1

• 编辑

朝来寒雨晚来风 519

6年前回答

• A、select * from users where a = 1 and b = 2

• 编辑

tianfeng 21

6年前回答

• A、select * from users where a = 1 and b = 2
• C、select * from users where a = 2 and c = 1

• 编辑

fed126 34

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

lzq603 1

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1

• 编辑

cffirm 7

6年前回答

• A、select * from users where a = 1 and b = 2
• C、select * from users where a = 2 and c = 1

• 编辑

Adamlet 32

6年前回答

• A、select * from users where a = 1 and b = 2
• C、select * from users where a = 2 and c = 1

• 编辑

薇尔莉特·伊芙加登是小天使 17

6年前回答

• A、select * from users where a = 1 and b = 2
• D、select * from users where b = 2 and c = 1

• 编辑

yuye 902

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1

• 编辑

yinshi 8

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

zerovszero 106

6年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

蛋蛋CC 1353

5年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1

• 编辑

lampyou 30

5年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

范德萨发 1

5年前回答

• A、select * from users where a = 1 and b = 2
• D、select * from users where b = 2 and c = 1

• 编辑

沐兰天姿 48

5年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1

• 编辑

liheheh 1

5年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1
• C、select * from users where a = 2 and c = 1

• 编辑

novayoung 29

4年前回答

• A、select * from users where a = 1 and b = 2
• D、select * from users where b = 2 and c = 1

• 编辑

待烟火清凉 812

4年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

mihx 68

4年前回答

• A、select * from users where a = 1 and b = 2
• B、select * from users where b = 2 and a = 1

• 编辑

dwaff 1

3年前回答