Any two rows in the table cannot have the same value or combination of values in the indexed columns.
You cannot specify UNIQUE for a secondary index:
- if you also specify ALL.
- for a secondary index defined on a join index.
- if you also specify an ORDER BY clause.
- for a column that has a LOB UDT or XML data type.