remove unused/bad index to speed up response from table <p>Hi I have table with stat below</p> <pre><code>Rows : 4,639,162 Reserved : 7,183,216 KB Data : 5,978,536 KB Index Size : 1,199,840 KB Unused : 4,840 KB </code></pre> <p>I have used <code>sp_spaceused 'TableName'</code> for this stat.</p> <p>And table information is like below</p> <pre><code>index_name index_description index_keys IX_tbl_tablename_1 nonclustered located on PRIMARY lng_clientid, str_facility_mims, str_group, str_eq_circ_id, int_tml_no IX_tbl_tablename_fullreport nonclustered located on PRIMARY str_eq_circ_id, str_facility, str_group IX_tbl_tablename_lng_clientid nonclustered located on PRIMARY lng_clientid PK_tbl_tablename_1 clustered, unique, primary key located on PRIMARY lng_id, lng_clientid </code></pre> <p>I am not expert on index but does these index seems okay ?? </p> <p>EDIT : I am Concerned about different Index created and having some common columns. Eg : Clustered Index is created with lngid and clientid , but there is non-clustered index too with only clientid. So is okay ??</p>