Simply select all tables you want to optimise or click on the Check All option and scroll down to the With Selected dropdown menu. Select Optimize table under the Table Maintenance section to automatically let phpMyAdmin optimise all selected tables in your WordPress database.
