How to Migrate CA APM Data from Release 11.3.4 to Release 12.8 › How to Migrate CA APM Data from Release 11.3.4 to Release 12.8 › Run the Pre-Migration Reports › Pre-Migration Report Data for Reference and Corrective Action › Custom Index Report › Remove Custom Indexes from Database

Remove Custom Indexes from Database

We recommend that you remove custom indexes from your database to avoid performance issues. Remove the indexes before you run the Migration Utility. The Custom Index Report provides the information that you use to remove the custom indexes.

Follow these steps:

1. Locate the Custom Index Report.
2. Copy the SQL statements from the Drop SQL column on the report.

   Note: Delete the quotation marks at the beginning and end of the statements.

3. Paste the SQL statements to your preferred tool, for example, Microsoft SQL Server Management Studio and Oracle SQL Developer, and run the statements.

   The following items are removed:

   • Custom indexes
   • Index definitions from the arg_index_member table
   • Index information from the arg_index_def table