碎片整理语句

create index StatisticsTagArea_AreaId on StatisticsTagArea(AreaId) include(TagId)

drop index StatisticsTagArea_AreaId on StatisticsTagArea

create index StatisticsTagArea_AreaId on StatisticsTagArea(AreaId) include(TagId,DisCount,DisHasPicCount)

dbcc showcontig(StatisticsTagArea,StatisticsTagArea_AreaId)  WITH FAST, TABLERESULTS,  NO_INFOMSGS

dbcc dbreindex(StatisticsTagArea,StatisticsTagArea_AreaId,90)

ALTER Index PK_STATISTICSTAGAREA on StatisticsTagArea rebuild 

dbcc INDEXDEFRAG (0,objectid,indexid)