Ricardo Sanchez
  • Home
  • Español
  • YouTube
  • About
  • Contact
Sign in Subscribe

SQL batch

How to (efficiently) delete millions of records in a SQL table

[Updated on 2024-06-30 based on feedback from comments] A while ago, I blogged about how to efficiently update millions of records in a SQL table, today I’d like to show you a simple trick to do the same when deleting millions of records in a SQL table. The idea
Ricardo Sanchez 20 Jan 2023

How to (efficiently) update millions of records in a SQL table

You need to update one or more columns in a table with millions of records with data from another table, what’s a good way of going this with low risk and in an optimized way? One of my favorite ways of dealing with millions of records in a table
Ricardo Sanchez 11 Sep 2020

Subscribe to Ricardo Sanchez

Don't miss out on the latest news. Sign up now to get access to the library of members-only articles.
  • Support our Writing
  • Connect
  • Sign up
  • Disclaimer
  • Privacy
  • Terms
Ricardo Sanchez © 2025. Powered by Ghost
Mastodon