How do you know which index a table is using?
sp_helpindex command gives the information of the indexes on the table