Step 1: Login to your cPanel and open your phpMyAdmin tool
Step 2: Select the database whose tables you wish to optimize.
Step 3: A list with all the database’s tables will appear.
Step 4: Tick the tables you wish to optimize, or simply click [Check All] to select all tables.
Step 5: From the [With selected:] drop-down menu choose Optimize table.
Step 6: This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.