The blog is not really topic specific. I will post random stuff which I find worth sharing. Solutions to little issues, tricks etc.

Friday, July 4, 2008

MySQL: Delete a subset in a table quickly

I found a fast way to delete a small subset of rows in a very big table (hundreds of thousands or millions).

See my comment on MySQL's DELETE Syntax page.

2 comments:

David Chaves said...

Have a look at one of the flies' books at O'Reilly: Optimizing Oracle Performance and Oracle Performance Tuning - this is already described there, since that it is not specific to Oracle nor MySQL

Martin Köbele said...

thanks David!
Probably should get those books, eh?