CREATE INDEX TEST_idx 
ON SCOTT.TEST(NAME)

CREATE INDEX TEST_idx 
ON SCOTT.TEST(NAME)
PARALLEL 4 NOLOGGING;

PARALLEL (NOPARALLEL is the default): Multiple processes can work together simultaneously to create an index. 
By dividing the work necessary to create an index among multiple server processes, the Oracle server can 
create the index more quickly than if a single server process 
created the index sequentially. 

NOLOGGING: Using this keyword makes index creation faster because it creates a very minimal amount 
of redo log entries as a result of the creation process.