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.