Database Administration (MOSC)

MOSC Banner

parallel index creation

edited Jan 23, 2011 5:37PM in Database Administration (MOSC) 7 commentsAnswered ✓
 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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center