以下SQL语句可有更优化的方法?
select ID from TableA A where (A.cont='wt.pdmlink.PDMLinkProduct')
and exists(select null from TableB B where exists(select null from TableA C where (C.ID in ('347162')) and (B.ColB = C.ColC)) and A.ID = B.ColA)
...全文
1692打赏收藏
以下查询如何优化?
以下SQL语句可有更优化的方法? select ID from TableA A where (A.cont='wt.pdmlink.PDMLinkProduct') and exists(select null from TableB B where exists(select null from TableA C where (C.ID in ('347162')) and (B.ColB = C.ColC)) and A.ID = B.ColA)