I see that in a production instance, they have been using Archive Rules to clean out VITs closed over 90 days ago. As a result, the Archive Vulnerable Item table has compiled over 118 million records over a period of 14 months. I also do not see any Archive Destroy Rules for this archive vulnerable item table. I would imagine this will have a negative impact of performance of the instance.
So my question is, are there any best practice recommendations for instead using a VR auto-delete rule using the same closed over 90+ day window? Could there be a reason to use archive instead for audit purposes? I greatly appreciate any feedback!
