These are the steps to optimize a database via phpMyAdmin in cPanel:
1. Log in to your cPanel account.
2. In the Databases section, click on phpMyAdmin.
![]()
3. Click on the Expand icon from the navigation tree in the left sidebar.

4. Scroll down and mark Check All.
Click on the drop-down option and select Optimize tables.

You have just optimized the table.