Disable Index
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
- Initiate a Disable Index(es) action against one or more indexes. For more information see Initiating an object operation.
- 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.