Understanding Parallel hints on Tables and parallels in Create table as well.

[lella2015]

Hi Guys,

I need some help in understanding how parallels work in different situations.

I got table A, B with parallel 10 degrees each.

When I run the below DML how it works and how many processors the DB look for

Create Table C PARALLEL (DEGREE 10) AS
SELECT A.* FROM A
JOIN B ON (A.COL1=B.COL1)

My server got 50 processors.

Can someone tell me what will be the performance of the query and what parallels I can use to tune it.

Regards,
Suresh