In which cases is reference partitioning ctive in enhancing performance?
A.
It is effective in both partition pruning as well as partitionwise joins irrespective of whether
the query predicates are different from or identical to the partitioning key.
B.
It is effective in both partition pruning as well as partitionwise joins provided that the
query predicates are identical to the partitioning key.
C.
It is effective only in partitionwise joins provided that the query predicates are different
from the partitioning key.
D.
It is effective only in partition pruning.