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)
碎片整理语句
原文：http://www.cnblogs.com/baozhu/p/7241974.html
