增加一个int字段竟然让整个SQL语句的执行时间翻了几倍
本帖最后由 robake 于 2013-01-16 14:09:36 编辑 数据库：SQL2008
有下边的SQL语句：
select a.VirusNameID1,a.DateTime ,b.Name,d.ID as SpywareExclusionId,
0 as t--,VirusTypeID
FROM VSDetections.dbo.VS_Detections365 a
Left join VSDetections.dbo.VS_VirusNames b ON b.Id=a.VirusNameID1
Left join VirusScanProd.dbo.MyCIOVirusName d ON d.VirusName=b.Name
Where MID =ANY
(Select ID From VirusScanProd.dbo.MyCIOMachine
Where ContactID=46)
--and VirusTypeID =ANY (Select VirusTypeID from VSDetections.dbo.MyCIOVirusTypeLookup
Where Category=2)
--and VirusTypeID>=20207
