drop and rebuild indexes
Moderator: General Moderators
drop and rebuild indexes
Is there any point in dropping and rebuilding indexes?
Re: drop and rebuild indexes
I would think it might help with really big tables that are always being access/modified and having rows inserted and deleted all the time. I know sometimes I have problems with my bigger tables getting indexing problems when mysql gets a timeout on a query and then I have to rebuild the indexes for mysql to be able to access those tables again. Has only happened to me twice in 6 years so hasn't been a huge issue for me.