Hi
We are running a script to delete data from multiple tables (like 100 tables) of which there are 5-6 big tables , which have nearly 8L rows and 200 columns . The script deletes nearly 21% of the rows.
Based on the logic in the script I can't write CTAS in the script and the table has no partitions . I can't use nologging as we have a DR system.
I would like the script to be as fast as possible .
Does dropping the indexes and rebuilding them after the delete job as completed increase the speed?
Pls provide any more suggestions to make the delete script to run fast