- Log into your cPanel account.
- In the Databases section, click on the phpMyAdmin icon.
- In left side-bar, Click on the expand button to expand the database like "example".
- 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.