I am looking at a number of WordPress plugins to optimize my databases. I did run across the WordPress method of optimizing a database.
First backup your database.
http://yourdomain.com/wp-admin/maint/repair.php
Click on the Repair Database button to have WordPress internally executes two SQL queries on each WordPress database table: CHECK TABLE and REPAIR TABLE
Click on the Repair and Optimize Database button to have WordPress internally executes the two SQL queries above and two additional SQL queries on each WordPress database table: ANALYZE TABLE and OPTIMIZE TABLE
I hope this improves my WordPress performance.