261.In which cases is reference partitioning effective in enhancing performance?
在哪些情况下是涉及分区有效地提高了性能？
D、它在分区修剪以及智能化分区连接都是有效的，不论是否查询谓词（判断）同分区键是不同或完全相同。
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.
Answer: D在哪些情况下是涉及分区有效地提高了性能？
D、它在分区修剪以及智能化分区连接都是有效的，不论是否查询谓词（判断）同分区键是不同或完全相同。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2123692/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q200
下一篇：
1Z0-053 V13.02 Q263
请登录后发表评论
登录
全部评论
