Keyword that defines a nonunique secondary index (NUSI) for the table.
You can define a secondary index on a column that has a UDT data type.
You can define a nonunique secondary index on a column that has a Geospatial data type.
If you specify INDEX without the preceding keyword UNIQUE, the index is a nonunique secondary index (NUSI).
The INDEX list is an extension to ANSI SQL.
Unlike the indexes created by the UNIQUE and PRIMARY KEY constraint definitions, indexes defined by the index list can have nullable columns.
You cannot define a secondary index on a column defined with any of the following data types:
- BLOB
- CLOB
- LOB UDT
- VARIANT_TYPE
- ARRAY
- VARRAY
- Period
- XML
- JSON
- DATASET
- index_name
- Optional name for the index.
- ALL
- Ignore the assigned case specificity for a column. This property enables a NUSI defined with the ALL option to do the following:
- Include case-specific values.
- Cover a table or join index on a NOT CASESPECIFIC column set.
- index_column_name
- Column set whose values are to be used as the basis for a secondary index.