Specifying Modes for Duplicate Indexes

You must observe the following rules when you specify modes for duplicate indexes in CREATE INDEX statements:

• You can set a duplicate index to enabled or disabled mode. Filtering mode is available only for unique indexes.
• If you do not specify the mode of a duplicate index, by default the index is enabled.