Oracle
1Z0-050 · Question #83
In which cases is reference partitioning effective in enhancing performance?
The correct answer is D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query. See the full explanation below for the reasoning.
Question
In which cases is reference partitioning effective in enhancing performance?
Options
- AIt is effective only in partition pruning.
- BIt is effective only in partitionwise joins provided that the query predicates are different from the
- CIt is effective in both partition pruning as well as partitionwise joins provided that the query predicates
- DIt is effective in both partition pruning as well as partitionwise joins irrespective of whether the query
How the community answered
(22 responses)- A9% (2)
- B5% (1)
- C14% (3)
- D73% (16)
Community Discussion
No community discussion yet for this question.