获得徽章 0
- 问：
1.走哪个索引
？
Explain select * from t_abc where 1=1 and a > '1'
2.走哪个索引
？
Explain select * from t_abc where 1=1 and b > '1'
3.这两都走a的索引么
？
EXPLAIN select * from t_abc where a = '上海' ;
EXPLAIN select * from t_abc where a = '河北' ;展开评论点赞 - 问：
1.走哪个索引？
Explain select * from t_abc where 1=1 and a > '1'
2.走哪个索引？
Explain select * from t_abc where 1=1 and b > '1'
3.这两都走a的索引么？
EXPLAIN select * from t_abc where a = '上海' ;
EXPLAIN select * from t_abc where a = '河北' ;展开1点赞 - 问：
1.走哪个索引？
Explain select * from t_abc where 1=1 and a > '1'
2.走哪个索引？
Explain select * from t_abc where 1=1 and b > '1'
3.这两都走a的索引么？
EXPLAIN select * from t_abc where a = '上海' ;
EXPLAIN select * from t_abc where a = '河北' ;展开赞过
评论1 - 问：
1.走哪个索引？
Explain select * from t_abc where 1=1 and a > '1'
2.走哪个索引？
Explain select * from t_abc where 1=1 and b > '1'
3.这两都走a的索引么？
EXPLAIN select * from t_abc where a = '上海' ;
EXPLAIN select * from t_abc where a = '河北' ;展开赞过 评论1
