Is always a good idea to keep your database' tables optimize.
Fortunately, making this optimization is quite easy when using phpMyAdmin tool available in cPanel.
To perform the optimization, log in to your phpMyAdmin and select the database whose tables you wish to optimize.
A list with all database' tables will appear. Tick the tables you wish to optimize or simply click [check all] to select al tables.
Click the box [with selected :] and choose optimize table. This will executed the OPTIMIZE TABLE SQL query on the selected tables and they will be update and optimize.
Original source : http://Siteground.com
