Hi,
I have to delete million of record every quarter from a database (Purge operation), It will read from file and get unique ID record which need to be deleted from ORACLE database table.
in this regards
How to perform Bulk delete?
Thanks,
Ranjan
How to perform Bulk delete oe optimize delete operation
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No such thing if you have to provide selective keys. The best you can do is to find the optimum balance between array size and transaction size. The first will be a function of your row size; the second should be an integer multiple of the first.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.