Hi Team,
I am in a need of mass deletion of records from location table. We closely have around 6 million records which needs to be deleted. What would be the best approach to go for bulk deletion of records.
As of now we planned to delete it with fix script using batching by storing sys_id and deleting those sys_ids using delete multiple. But I would like to know any other process of deleting records without much performance impact and if anyone can share any optimized code for deleting records.
Thanks in advance
Thanks
Ashwin Perumal G
