I have a table with 1,000,000 records, and I run an instruction that deletes ~ 700 thousand rows. The auto increment index, of course, is 1,000.001. The highest primary key is subsequently, for example, 40,000.
After such a huge row deletion, should I manually set the index to 40,001 or optimize the table in some way? Or does MySQL not care about this huge gap when inserting new rows and using the index in select operations after (in terms of speed)?
source
share