Cleaning the database

Use the Database Cleanup utility to delete unused or obsolete objects from the database.

You can run the utility in the default online mode or in an offline mode to delete object records from database tables. If you are deleting objects that are stored in a table hierarchy that is not deeply or widely nested, run the utility with the default online behavior. If you are deleting a large number of objects from the database that are stored in a deeply or widely nested table hierarchy, consider running the Database Cleanup utility offline. By running the utility offline, you can reduce the performance impact of deleting these records in these types of hierarchies. For more information, see Database Cleanup utility.