I have a 200GB table with a foreign key constraint, and I need to drop an existing index and add a non-unique index to it. 

What is the best approach to do this with minimal impact on users?

Thanks 

Edi