SQLSERVER语句 in和exists哪个效率高本人测试证明?

Question

SQLSERVER语句 in和exists哪个效率高本人测试证明

Answer 1

例如下面两个SQL语句1 SELECT OrderNo, SiteCode, AreaCode2 FROM SchedulingProgram3 WHERE AreaCode IN ( 'P', 'M' ) AND SiteCode IN ( SELECT SiteCode4 FROM EnvBasicInfo5 WHERE cityiD = 31 ) AND OrderNo NOT IN (6 SELECT OrderNo7 FROM KK_DeliveryinfoTmp )上面SQL语句IN里面有IN和NOT IN1 SELECT OrderNo, SiteCode, AreaCode