There is pro and con for having indexes on the table.
The pro is when you use select statement indexes will help boost up the query. However, when you do DML statement (insert, update, delete) you might run into performance issue.
The work around of this when you need...
