Which statement is true for you to get the benefits of partition-wise joins?
A.
The parent table must be partitioned on the join Key and the child table must be partitioned on]
the join key.
B.
The parent table must be partitioned on the primary key and the child table must be partition the
join key.
C.
The child table must use a reference partition.
D.
The parent table must be partitioned on the primary key and the child table must use a ref
partition.
Explanation:
Note:
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
operations.
Partition-wise joins can be full or partial. Oracle decides which type of join to use.