How to rebuild search indexes on a table.

If you make server changes that could affect your indexes then you will need to rebuild your index in order to pick up new settings.

Step-by-step guide

Execute this MySQL command on the table required

REPAIR TABLE <TableName> QUICK;