2个语句:
select * from table1 a inner join table2 b on a.bid=bid where a.bid=3 and b.no='0001' and ....
跟
select * from table1 a inner join table2 b on a.bid=bid and a.bid=3 where b.no='0001' and ....
这样的语句,效率是否有区别呢,
那句语句的效率比较高,
...全文
8910打赏收藏
sql语句执行效率分析
2个语句: select * from table1 a inner join table2 b on a.bid=bid where a.bid=3 and b.no='0001' and .... 跟 select * from table1 a inner join table2 b on a.bid=bid and a.bid=3 where b.no='0001' and .... 这样的语句,效率是否有区别呢, 那句语句的效率比较高,