sql优化or

Question

如何优化sql查询select id from user where phone=’131′ or phone=’139′

Answer 1

explain select id from user where phone=131 union select id from user where phone=139;试试这条语句