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;試試這語句