Enable Keys
Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]
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
- Initiate an Enable Keys action against one or more tables. For more information see Initiating an object operation.
- The Enable Keys dialog opens.
- 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. | |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
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.
