请高手帮忙:
请问下面的语句有没有更快的查询方式(用in太慢了)
select * from order_item where mas_pk_no in (select pk_no from order_mas where org_no=? and loc_no=? and mas_no=?
and mas_code=?)
请问下面的语句有没有更快的查询方式(用in太慢了)
select * from order_item where mas_pk_no in (select pk_no from order_mas where org_no=? and loc_no=? and mas_no=?
and mas_code=?)
select a.* from order_item a,order_mas b where a.mas_pk_no = b.pk_no b.org_no=? and b.loc_no=? and b.mas_no=?
and b.mas_code=?