I've got a table with 120k rows, and I need to delete some rows if there is a specific condition.
I wrote this:
if db.INTERVENTION(i)==1 && isequal(db.SETTLEMENTDATE(i-1),db.SETTLEMENTDATE(i)) && isequal(db.DUID(i-1),db.DUID(i))
This code takes a long time to execute.
Is there a faster way?