How to speed up deleting rows, when there are child tables?
Posted on 2013-06-11
I want to delete nearly 9000 rows from a table of 4 million rows.
The table is having two child tables.
The table is having primary key.
primary key is used when deleting.
I tried the following, but still it is taking 3 hours
Delete using ROWID.
Please let me know is there any other general approach, I can try.
If you want I want, I can post more details tomorrow.