Oracle 9.2.0.8
We are looking at application database data scrub process. There are about 50 tables to delete from. Number of records varies from 30M to 30K.
In some cases, we will delete half of total count. I know that the best way to delete large number of rows is to create table as ... , rebuild indexes, rename original table, rename new table into original name, drop original table.
Question: how does one determine when to use this approach as appose to simply run a delete statement? Is there a percentage of the total that I need to look at? Am I overthinking it?
Thanks,
Eugene