Composite Index

A composite index is built on two or more columns of a table:


CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,
                      ENAME VARCHAR2(10),
                      HIREDATE DATE);
                      

SQL> CREATE INDEX INDEX_EMP ON EMP(EMPNO, ENAME);

Index created.

SQL>
Home »
Oracle »
Table » 

Index:
  1. Creating a B-tree Index
  2. Composite Index
  3. Retrieving Information on Indexes
  4. Modifying an Index
  5. Dropping an Index
  6. Creating a Bitmap Index
Related: