mysql - optimize database

[symptome]

There is a function within vb to optimize the database.
Is this enough to get the most out of it?
Or are there further optimization tools, probably only within the database administration itself, to do that? Something like index rebuilds and more.

Thanks a lot!