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 »
Oracle »
Table »
Index:
- Creating a B-tree Index
- Composite Index
- Retrieving Information on Indexes
- Modifying an Index
- Dropping an Index
- Creating a Bitmap Index
Related: