Creator of table or users that have the SYS_ADMIN_ROLE role
Usage
Use the CREATE INDEX statement to create an index for a table that is based on the given columns.
▪ UNIQUE: Specifies that the column(s) that are indexed must contain unique values. If more than one column is specified, the combination of columns must have a unique value, but the individual columns do not need to have unique values.
For example, if you create an index on the combination of LAST_NAME and FIRST_NAME, the following data values are acceptable because although there are duplicate first names and duplicate last names, no 2 rows have the same value for both first name and last name.
SMITH, PATTI SMITH, DAVID JONES, DAVID
▪ ASC and DESC: Specify whether the given columns should be indexed in ascending or descending order. If neither ASC nor DESC is specified, ascending order is used.
If index‑name starts with a digit, the value must be enclosed in double quotation marks.
After you create an index, you must commit (or roll back) your work before you can modify the data in the table on which you created the index.
Examples
CREATE UNIQUE INDEX UX_TEST ON TEST (I); CREATE INDEX X_TEST ON TEST (I DESC, J DESC); CREATE INDEX "053_TEST" ON TEST (I DESC, J DESC);