search

Home  >  Q&A  >  body text

sql optimization or

How to optimize sql query select id from user where phone=’131′ or phone=’139′


Alone.Alone.2426 days ago1241

reply all(1)I'll reply

  • 无忌哥哥

    无忌哥哥2018-06-14 11:04:32

    explain select id from user where phone=131 union select id from user where phone=139; try this statement

    reply
    0
  • Cancelreply