You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.
The audit table had grown to 200 million rows, so the team finally ran the purge: everything older than 90 days, gone. Ninety-nine percent of the rows deleted, committed, celebrated. The next morning
uptimearchitect.hashnode.dev12 min read