Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Index with the PARALLEL 4 option...

unknown-2973982Feb 22 2016 — edited Feb 23 2016

Hello All, I hope this finds you all in Good Spirits.

I had one of my Developers create an index today in one of our many test environments against a table that had many millions of rows in it and they used the

"PARALLEL 4" option.

Does the PARALLEL 4 option create 4 threads on the database to create it faster?

What does that option actually do?

thanks,

Lady Allora.
This post has been answered by Paulzip on Feb 22 2016
Jump to Answer

Comments

3474044
Answer

SOLVED:

Solution:

Add the following to SQL Workshop ---> SQL SCRIPTS ---> CREATE --> RUN

DELETE YOURS_TABLE_NAME WHERE EMTY_COLUMN_NAME IS NULL;
Marked as Answer by 3474044 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 22 2016
Added on Feb 22 2016
#index
12 comments
611 views