Database DataWarehousing (MOSC)

MOSC Banner

is there a need to setup The Parallel Execution Server Pool for parallel index creation?

edited Apr 4, 2014 12:00PM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hi,

I want to use the following DDL

CREATE INDEX cust_dup_idx ON customer( customer_id) PARALLEL 35 NOLOGGING;

Do I need to setup The Parallel Execution Server Pool before running the statement?

What if I just run it without setting Parallel Execution Server Pool? Would it execute in parallel as expected, assuming Oracle server is on multi-core machine?

Thanks,

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