Oracle Tips: Speeding up Index Creation

3 Steps to create indexes faster

1. CREATE INDEX on <table_name>(<column1>, <column2>) UNUSABLE;
2. ALTER INDEX REBUILD parallel 16 NOLOGGING;
-- Does FFS rather than FTS when using Create statement
3. ALTER INDEX NOPARALLEL;