1. Log in to your cPanel account.
2. In the Databases section, click on the phpMyAdmin icon.

3. On the left sidebar, click on your database to expand the database tables.
4. Under your cPanel username, you can see a list of all databases. Select the appropriate database that you want to optimize.
5. Scroll down and mark Check All, then click on the Drop-down option and select Optimize Tables or Repair tables.

Table successfully optimized or repaired.