Oracle Indexes

Oracle Indexes

Index creation

Create an index online in parallel

1

CREATE INDEX <SCHEMA>.<NAME> ON <SCHEMA>.<TABLE>(<COLUMN>,<COLUMN>,...) ONLINE PARALLEL X;

Example:

1

CREATE INDEX EXAMPLE.MYINDEX ON EXAMPLE.MYTABLE(COLUMN1,COLUMN2) ONLINE PARALLEL 8;

Find indexes on table

1
2
3
4
5
6

column INDEX_NAME format a30
column TABLE_OWNER format a30
column TABLE_NAME format a30
column UNIQUENESS format a20
set linesize 120
SELECT INDEX_NAME, TABLE_OWNER, TABLE_NAME, UNIQUENESS FROM ALL_INDEXES WHERE TABLE_NAME = 'XX'