Step 1:go to Site Configuration >> DB Maintenance
Step 2: Select how often to optimize the tables (this runs a cron job)
Step 3: Select the tables you want to optimize
Step 4: drupal_7_optimize_3
Step 5: Click “Optimize now” to Optimize the selected tables now or “Save Configuration” to run optimize on the schedule you chose.