--索引查找次数
select 'DatabaseName' as dbname, b.name,
user_seeks, last_user_seek, user_scans, last_user_scan, rows
from sys.dm_db_index_usage_stats a
join sys.indexes b on a.index_id = b.index_id and a.object_id = b.object_id
join sysindexes c on b.object_id = c.id and b.index_id = c.indid
where database_id = db_id('DatabaseName')
and b.name = 'IndexName'

--整理索引碎片
select b.name,o.name,avg_fragmentation_in_percent 
from sys.dm_db_index_physical_stats (DB_ID(N'DatabaseName'), null, NULL, NULL, NULL) as a
JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id
join sys.objects as o on o.object_id = b.object_id
where b.name is not null
and avg_fragmentation_in_percent >= 10
order by avg_fragmentation_in_percent desc

alter index IndexName on TableName
REORGANIZE