Create Index in Oracle Examples

Create Index in Oracle Examples

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

Below are the examples of CREATE INDEX in Oracle.

Create a Unique Index

In the following example, it will create a unique index on the EMP table for column EMPNO.

CREATE UNIQUE INDEX emp_unique_index
ON EMP (EMPNO)
/

Create a Non-Unique Index

In the following example, it will create a non-unique index on the EMP table for columns EMPNO, ENAME, and JOB.

CREATE INDEX emp_nonunique_index ON EMP
(EMPNO, ENAME, JOB)
/

See also: