可以把语句改成 LEFT JOIN ,在where做为空的筛选。例如select v1.* from table v1left join icclientver v2 on v1.finterid = v2.finterid and v1.fentryid = v2.fentryid where v2.finterid is null
顶楼上的,not in这种查询方式都可以用left join替代,然后再过滤
... from v1 where not exists (select 1 from icclientver b where v1.finterid =b.finterid and v1.fentryid=b.fentryid )
请问如果改语句的话,要如何修改,not exists提升很有限啊。
where v2.finterid is null
(select 1 from icclientver b where v1.finterid =b.finterid and v1.fentryid=b.fentryid )