Update data activity is taking too much time to run in Adobe Campaign while updating bulk amount of data in recipient table. Around 30 mins for updating 900000 number records. The table contains around 30 M records. The reconciliation key is having an index on it (it is the primary key column).Is there any scope for improvement?
Thanks for your input. I am doing it in low activity period only and other than out of the box indices, there are two more indices in the extended schema and I am only performing update. Next thing is the DB health, let me check that.