On Wed, Jan 15, 2025 at 9:54 AM Gambhir Singh <gambhir.singh05@xxxxxxxxx> wrote:
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
Maybe the delete "queries" are poorly written. Maybe there's no supporting index.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
