- Log into your cPanel account.
- In the "Databases" section, click on "phpMyAdmin" Icon.
- In the left sidebar, click on the Expand button to expand the database.
- Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to optimize.
- Scroll down and mark "Check All" then click on the Drop-down option and select "Optimize Tables."
Table successfully optimized.