Table of Contents
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;