CORACLEANUP performance. How to speed up CORACLEANUP processing.
There are many factors that impact CORACLEANUP performance:
Prior to running CORACLEANUP, you can manually check the database for duplicate entries and resolve some of the duplicates manually. To check the mdb for duplicate CORA fields, use the query below and run it once for each of the 6 CORA fields, substituting <fieldName>, for one of the following 6 fields.
NOTE: When deleting asset information, do NOT delete records from the backend database. Use either the ITAM data importer or the delete option within the APM graphical interface.