一个20W条数据的表,查询条件语句 哪个快一点. 1.where id in (1,2,3,4) 2.where id=1 or id=2 or id=3 or id=4 虎年好运！虎年好运！ SQL code: select * from tb where id=1 union all select * from tb where id=2 union all select * from tb where id=3 union all select * from tb where id=4
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 上面一个简单的SQL,执行时间2.6� ......
