22,301
社区成员




--1. 删除原来没用的索引
DROP INDEX [FloatTableIndex] ON [dbo].[FloatTable]
--2. 建立新索引
CREATE NONCLUSTERED INDEX [FloatTableIndex] ON [dbo].[FloatTable]( [TagIndex], [DateAndTime] )
select tagindex,count(1) as cnt
from [xw].dbo.floattable with(nolock)
group by tagindex;
先查一下, 贴截图出来