ISSUE

On the development environment we host a handful of build-on dev application for our teams.

However, now we are facing the following issue:

System-Application-RuleSetIndex

and

System-Application-Hierarchy-Flat

are being populated with instances from all applications. This should not be a problem, until we noticed a slow down in our dev studio.

There are now millions of instances.

1. It is advised not to truncate these tables.

2. How can we manage these instances?

3. When is this table populated? For example, deleting all references of a team dev application will not delete corresponding instances in these classes.