Hello experts,
i would like to go for an option where i would like to delete around 3000 records from a custom entity, that might grow about 850k records per year. The bulk delete job will run during off business hours, nightly. it has one child entity, that might have 2 or 3 records for each parent record. i would like to know if it would create any performance problem accessing this custom entity in the short or long run. Appreciate your valuable comments. Thanks!