parallel index creation
hi
i want to create a simple index and for making the process faster i want to use parallel option. want to make sure that using this option does not affect the operation of index after creation.i am not sure if it is an option used for the time it is being created or it is an option used afterward as well.Please advice.
CREATE INDEX idx_emp ON emp2
(col2)
LOGGING
TABLESPACE test
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
PARALLEL (DEGREE 4);
CREATE INDEX idx_emp ON emp2
(col2)
LOGGING
TABLESPACE test
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
PARALLEL (DEGREE 4);
0