Enable Keys

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

You can issue an ALTER TABLE statement that specifies the ENABLE KEYS option. This action tells MySQL to recreate missing indexes.

Platform Availability

To Recreate Missing Indexes

  1. Initiate an Enable Keys action against one or more tables. For more information see Initiating an object operation.
    The Enable Keys dialog opens.
  2. Use the following table as a guide to understanding and modifying settings in this wizard:
Step Settings and tasks

Action Options

Lets you review the tables you selected.


Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.


Displays the DDL that will execute the object action. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.
Note: You can also instruct MySQL to stop updating nonunique indexes. For details, see Disable Keys.