Who can hold my hand to refresh table indexes

kklosson

It is certain that I need to rebuild the indexes on a table (maybe more than one table) but I've never done it. I am not confident about which command to use. All help is appreciated and I will gladly compensate. Please PM me if you have experience.

Jaymer

I could help, but I hate MySQL.
I really only use MSSQL.
It’s interesting why you think indexes need to be rebuilt?
Where did the indexes come from?
You need to have some sort of MySQL management tool, and the “rebuilding” is really nothing more than Dropping and re-creating it.
Are these manual indexes that you added after the fact, or are they from clicking the checkbox inside aware?

kklosson

Thanks. It appears I can use the Optimize Table command, which in MySQL actually performs an alternate function as the docs explain here: