Tuesday, October 28, 2008

eliminating redundant indexes from your mysql database

To find redundant (unneccesary) indexes in your mysql database, try the information schema views in
Roland Bouman's Redundant Index Finder. To delete them, try the procedure I_S_REDUNDANT_INDEXES_DROP which I just posted to the Community Feedback section.