In which cases is reference partitioning effective in enhancing performance？（） <br>A: It is effective only in partition pruning.<br>B: It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.<br>C: It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.<br>D: 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.

In which cases is reference partitioning effective in enhancing performance？（）
A: It is effective only in partition pruning.
B: It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C: It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D: 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.

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

收藏本站【zk.995w.com】，下次访问不迷路

本站试题总数:【10245188】个 (题库试题定时更新)