This technical document outlines the steps necessary for adding indexes to the heavily used snapshot database tables to improve the data write operation during a snapshot. This applies to CA Identity Manager r12 CR10 or later.
For further information of the details of the issue, please see the Release Notes for CA Identity Manager r12.0 CR10; the solution outlined in the "Solution" section should be performed in addition to the steps outline here.
In order to improve the snapshot export performance, the following steps should be performed in order to add needed indexes. Also provided are the commands to remove these indexes if needed.