INDEX

-- LOCAL INDEX
CREATE INDEX TABLE_SCHEMA.INDEX_NAME
ON TABLE_SCHEMA.TABLE_NAME
(
COLUMN1 ASC,
COLUMN2 ASC
)
TABLESPACE TABLESPACE_NAME 
NOCOMPRESS
PARALLEL 32 LOCAL
(
PARTITION PARTITION_NAME
TABLESPACE TABLESPACE_NAME
NOLOGGING,
PARTITION PARTITION_NAME
TABLESPACE TABLESPACE_NAME
NOLOGGING
);


CREATE UNIQUE INDEX TABLE_SCHEMA.INDEX_NAME
ON TABLE_SCHEMA.TABLE_NAME
(
COLUMN ASC
)
TABLESPACE TABLESPACE_NAME
NOLOGGING
NOCOMPRESS
PARALLEL 32;