Best approaching for adding custom Indexes?

Yes, in production it will keep all the compound indexes. So just create them manually with no worries.