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:

Screenshot_7.png (59.77 KiB) Viewed 10936 times