问：
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 = '河北' ;
展开
评论
点赞
