Oprimizing Oracle Delete Query
Posted on 2002-06-07
I am using Oralce as a back end for my payroll application. One of my payroll table having more than 5 lakhs records. My problem is deleting records from that table. Let say If I want to delete some 70000 records. What is happening is either the delete query taking more than 2 minutes or it saying rollback segement problem.
My question is how to faster the delete query. If i am able to stop using rollback segement(or redo log buffer for roll back facility) my delete query will be faster. I don't want a roll back facility for my delete query.
Can any body help me regarding the above problm.