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
Maybe the delete "queries" are poorly written. Maybe there's no supporting index.