You were right robert, we have improved the performance by optimizing the query and using the temp tables. but, can we improve it furthur if we use "Table" variable instead...

In oracle there is something known as rowid, i think you can use that to delete the second rec.