Disable Index

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Disable Index(es) action lets you mark an index as disabled or inactive and unavailable for use.

Platform Availability

Note: On SQL Server this action can also be applied to primary keys and unique keys.

To Disable an Index

  1. Initiate a Disable Index(es) action against one or more indexes. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the wizard:
Step Settings and tasks

Action options

Displays the name of the index, primary key, or unique key being disabled.

Dependencies

Review the referring and referred objects that will be automatically resolved when you execute this operation. For more information, see Dependencies.

Preview

Preview the DDL generated for the operation. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.