I consider adding some new Indexes on a table that is in the Production Db. and my concern is 'how to make it without having an impact on the users'

**Question**: (If it is not a BAD Idea) How can I be sure that it would not harm/impact the users to add extra indexes on a table in PRODUCTION Db. that has more than 5 million records?