Need an idea to operate massive delete operation on big size table.

[Gambhir Singh <gambhir.singh05@xxxxxxxxx>]

Hi,

I received a request from a client to delete duplicate records from a table which is very large in size. 

Delete queries (~2 Billion) are provided via file, and we have to execute that file in DB. Last time it lasted for two days. I feel there must be another way to delete records in an efficient manner

This kind of activity they do every month.

--

Thanks & Regards
Gambhir Singh