The SQL Rebuild Index command rebuilds an automatic index.

REBUILD INDEX <index-name>

Where:

• index-name name of the index. Use * to rebuild all the automatic indices

    REBUILD INDEX Profile.nick

    REBUILD INDEX *

For complete index guide look at Index guide.

To know more about other SQL commands look at SQL commands.