drop and rebuild indexes

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

drop and rebuild indexes

Post by GeXus »

Is there any point in dropping and rebuilding indexes?
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: drop and rebuild indexes

Post 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.
Post Reply