Which statement is true for you to get the benefits of partition-wise joins?

Question

Options

• AThe parent table must be partitioned on the join Key and the child table must be partitioned on]
• BThe parent table must be partitioned on the primary key and the child table must be partition the
• CThe child table must use a reference partition.
• DThe parent table must be partitioned on the primary key and the child table must use a ref

• A
  3% (1)
• B
  11% (4)
• C
  5% (2)
• D
  81% (30)

Explanation

A REF partition is another form of partitioning that reduces overhead, as well as saving storage space. Having parent and child tables in a foreign key relationship is a common implementation practice, especially since this architecture allows for partition-wise joins. A REF partition on the child simply points back to the parent and instructs Oracle to use the same partition scheme as the parent. 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.

No community discussion yet for this question.