If you want your Joomla website to run as smooth as you can, you have to optimize your MySQL tables at some point.
If you work with your PHP Admin software, you now how time consuming this can be, although you can have some scripts made up to do this maintenance task more easily.
But it would be great if you could do this just from withing your Joomla admin panel, instead of login into you hosting admin panel and then into the PHP Admin?
Joomla! Database Health Check Component
Its a simple component to install, and for most part you don't even have to set the configuration parameters like the Name of the Database Table, User name, server of password.
Please make a back-up of your database before you run this component, although I have had no problems any time I ran the component.
It runs fast, and gives you a nice list of what tables where repaired and which ones where optimized!
Yes, it even optimizes your database tables!
A very nice component, that you should use once a month ar so.
And as a bonus they have another nice Plugin for you to keep you site optimized and running, you can read more about that on my http://seo4joomla.wordpress.com site.