When two inputs that we desire to pipeline into the join are not already sorted it is the _____________ technique.
A. Hash join
B. Buffer join
C. double-pipelined hash join
D. double-pipelined join
Answer:A
When two inputs that we desire to pipeline into the join are not already sorted it is the _____________ technique.
A. Hash join B. Buffer join C. double-pipelined hash join D. double-pipelined join
Explanation: When hash indices are used on tuples, the resultant algorithm is called the double-pipelined hash-join technique..