MYSQL 中 OR 走不走索引

目录

添加a、b独立索引

添加a、b组合索引 

---

新建表test01，字段：id、a、b、c

添加a、b独立索引

EXPLAIN SELECT * FROM test01 WHERE a = 1 OR b = '1';

不走索引

EXPLAIN SELECT * FROM test01 WHERE a = 1 OR a = 2;

 走索引

EXPLAIN SELECT * FROM test01 WHERE b = '1' OR a = 1 ;

不走索引

EXPLAIN SELECT * FROM test01 WHERE b = '1' OR b = '1' ; 

走索引

添加a、b组合索引 

EXPLAIN SELECT * FROM test01 WHERE a = 1 OR b = '1' ; 

不走索引

EXPLAIN SELECT * FROM test01 WHERE a = 1 OR a = 1 ; 

走索引

EXPLAIN SELECT * FROM test01 WHERE b = '1' OR b = '1'; 

不走索引

EXPLAIN SELECT * FROM test01 WHERE b = '1' OR a = 1; 

不走索引