22,209
社区成员
发帖
与我相关
我的任务
分享
Select Top 16 a.id,a.id,a.cpmc,b.qymc as gsmc,a.cpsb,a.cpbh,a.cpcd,a.cpgg,a.cpjg,a.jysm,a.picture FROM dbo.productshow a left join corporation b on a.gsid=b.id Where 1=1 and a.typeid='55521615' And a.id Not In (Select Top 0 a.id FROM dbo.productshow a left join corporation b on a.gsid=b.id Where 1=1 and a.typeid='55521615' Order By a.id desc , a.idate desc )Order By a.id desc , a.idate desc
CREATE INDEX IX_productshow_Query ON productshow(cpmc,cpsb,cpbh,cpcd,cpgg,cpjg,jysm,picture)
CREATE INDEX IX_corporation ON corporation(qymc)
CREATE INDEX IX_productshow ON productshow(gsid,typeid)
CREATE INDEX IX_productshow_Date ON productshow(idate)
先执行这两个索引,再看看性能,2000有点麻烦,可能需要建多一点索引来覆盖查询