Who Can Create an Index?
The CREATE INDEX
statement can be executed by:
-
The owner of the table
-
Users with the
ALTER ANY TABLE
privilege
The CREATE INDEX
statement can be executed by:
The owner of the table
Users with the ALTER ANY TABLE
privilege
Specifying the keyword UNIQUE
in the index creation statement creates an index in which uniqueness will be enforced throughout the table.The index is referred to as a “unique index”.A unique index is not a constraint.
Unique indexes cannot contain duplicate key values (or duplicate key value combinations, in the case of compound, or multi-column, or multi-segment) indexes.Duplicated NULL
s are permitted, in accordance with the SQL standard, in both single-segment and multi-segment indexes.