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'