Why does partitioning help parallelism with RAC?

The correct answer is A. The ability to do partition-wise joins reduces interconnect traffic. Partition-wise joins reduce query response time by minimizing the amount of data exchanged among parallel execution servers when joins execute in parallel. This significantly reduces response time and improves the use of both CPU and memory resources. In Oracle Real Application…

Partitioning

Question

Options

AThe ability to do partition-wise joins reduces interconnect traffic.
BPartitioning allows you to split data storage across nodes.
CPartitioning reduces storage requirements.
DRAC will spawn additional parallel servers to meet the needs of requesting applications.

How the community answered

(41 responses)

A
78% (32)
B
12% (5)
C
2% (1)
D
7% (3)

Explanation

Partition-wise joins reduce query response time by minimizing the amount of data exchanged among parallel execution servers when joins execute in parallel. This significantly reduces response time and improves the use of both CPU and memory resources. In Oracle Real Application Clusters (RAC) environments, partition-wise joins also avoid or at least limit the data traffic over the interconnect, which is the key to achieving good scalability for massive join Partition-wise joins can be full or partial. Oracle decides which type of join to use.

Topics

#partition-wise joins#RAC#interconnect traffic#parallelism

Community Discussion

No community discussion yet for this question.

Full 1Z0-515 Practice