Who can hold my hand to refresh table indexes
Who can hold my hand to refresh table indexes
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.
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
Re: Who can hold my hand to refresh table indexes
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?
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?
Last edited by Jaymer on Tue Aug 15, 2023 2:22 am, edited 1 time in total.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Who can hold my hand to refresh table indexes
Thanks. It appears I can use the Optimize Table command, which in MySQL actually performs an alternate function as the docs explain here:
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit