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.
正确答案
答案解析
相似试题
(单选题)
Which built-in do you use to determine which timer in form module has expired?()
(多选题)
In which three cases does a checkpoint occur? ()
(多选题)
In which scenarios would you rebuild an index?()
(多选题)
In which two conditions are resumable statements suspended?()
(多选题)
In which three situations is incomplete recovery required?()
(单选题)
Which capability exists only in java.io.FileWriter?()
(单选题)
In which scenario will you create a hash cluster?()
(单选题)
In which scenario will you perform an incomplete recovery?()
(多选题)
Identify two situations in which the block header grows in a data block. ()