

 
select * from sys.dm_db_index_usage_stats 
select * from sys.dm_db_missing_index_details
select * from sys.dm_db_missing_index_group_stats
select * from sys.dm_db_missing_index_groups

-- Dynamic management functions
select * from sys.dm_db_index_operational_stats (dbid, objid, indid, partition_number)
select * from sys.dm_db_index_physical_stats(dbid, objid, indid, partition_number, mode)
select * from sys.dm_db_missing_index_columns(index_handle)




  
 
