Disable Keys

Go Up to Available object actions by DBMS

This action lets you build and submit an ALTER TABLE statement that specifies the DISABLE KEYS option. This action tells MySQL stop updating nonunique indexes.

Platform Availability

• MySQL

To Stop Updates to Nonunique Indexes

1. Initiate a Disable Keys action against one or more tables. For more information see Initiating an object operation.

   The Disable 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.
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 subsequently recreate missing indexes. For details, see Enable Keys.