Remove unnecessary objects from the Business Process Choreographer database

You can improve the performance of your database by deleting or archiving runtime objects after they are no longer needed.

About this task

During normal operation, new runtime objects are created in the Business Process Choreographer database. Unless you take regular actions to remove unnecessary objects, the database will keep growing, which can reduce the performance.

Procedure

If you have configured the Business Process Archive Manager, you can run the archive.py script to move completed process instances and human tasks to an archive database.
Delete any data in the database that cannot be archived when the data is no longer required. You can use one of the Business Process Choreographer cleanup procedures to delete the data.
If none of your applications use the Business Flow Manager or Human Task Manager query or query table APIs, you can run the optionalUpgradeIndexes.sql script to remove the indexes that are only used by those APIs. If you have not already dropped these indexes, remove the redundant indexes.