Advantages of Intra-Operation Parallelism
1) it speeds up the query processing by parallely executing the individual operations in the query.
2) It can scale better with increasing parallelism.
Disadvantages of Intra-Operation Parallelism
1) The cost of parallel evaluation of operations is considerable.
2) A partitioned parallel evaluation is only as fast as slowest of the parallel executions.
3) Any skew in, the distribution of work across CPU's greatly affects the performance.