Find index on a table

Normally when there is an issue on the performance one really want to see how many indexes are defined on a table.

the simpest command to get this information is sp_helpindex where just pass the tablename as the input parameter to the procedure then it will list out all the indexes defined on that table.