is there a need to setup The Parallel Execution Server Pool for parallel index creation?
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,