Recommended deletion method for 1Million software-installation records

pavan Punna
Tera Contributor

Hi Community,

We need to delete approximately 1 million filtered records from cmdb_sam_sw_install while leaving sys_object_source unchanged.

A prior cleanup used a recurring Scheduled Script Execution with setWorkflow(false) and record-by-record deleteRecord() in 10K batches. Each batch took approximately 35–37 minutes. We are also considering a Data Management Delete Job, Table Cleaner, or controlled deleteMultiple().

A recent Delete Job for 82K records on another table took two days, so we are concerned that one 800K execution may run continuously for several weeks.

For a one-time filtered cleanup, which method is safest and fastest while still supporting batching, restartability, and progress validation?

0 REPLIES 0