方案1:select top 5 Failure ,count(Failure) from Fix Group by Failure 增加Failure列的索引
CREATE INDEX IX_Fix_Failure ON Fix (ID, Failure)
CREATE INDEX IX_Fix_Failure ON Fix (ID, Failure)
方案2:
set RowCount 5
select count(Failure) from Fix group by Failure
set RowCount 0