Getting all the relevant information needed to see your indexes on the table: select ps . database_id , ps . object_id , o . name , o . type_desc , ps . index_id , b . name as index_name , ps . avg_fragmentation_in_percent , ps . avg_page_space_used_in_percent...