索引使用获取

select * from sys.dm_db_index_physical_stats(db_id(),object_id('District'),12,null,null) 

SELECT * FROM sys.indexes a WHERE a.name='District_ProvinceId'