Page 1 of 1

drop and rebuild indexes

Posted: Thu Jan 17, 2008 2:51 pm
by GeXus
Is there any point in dropping and rebuilding indexes?

Re: drop and rebuild indexes

Posted: Thu Jan 17, 2008 3:31 pm
by Jade
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.