SET INDEXES

Use the SET INDEXES statement to enable or disable an index, or to change the filtering mode of a unique index.

Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL. Do not confuse the SET INDEXES statement with the SET INDEX statement.

Syntax

                  .-,-----.
                  V       |
>>-SET INDEXES--+---index-+--+---------------------------------->
                '-FOR--table-'
 
>--+-+-ENABLED--+-----------------+----------------------------><
   | '-DISABLED-'                 |
   |            .-WITHOUT ERROR-. |
   '-FILTERING--+-WITH ERROR----+-'

Element	Description	Restrictions	Syntax
table	Table whose indexes are all to be enabled, disabled, or changed in their filtering mode	Must exist	Database Object Name, p. Database Object Name
index	Index to be enabled, disabled, or changed in its filtering mode	Must exist	Database Object Name, p. Database Object Name

Usage

The SET INDEXES statement is a special case of the SET Database Object Mode statement. The SET Database Object Mode statement can also enable or disable a trigger or constraint or change the filtering mode of a constraint.

For the complete syntax and semantics of the SET INDEXES statement, see SET Database Object Mode.