IBM Exam Questions

What type of join processing will occur when the query is executed?

Refer to the exhibit.

Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey =
TableB.o_custkey; What type of join processing will occur when the query is executed?

A.
“Collocation hash join processing

B.
“Distributed hash join processing

C.
“Broadcast sort merge join processing

D.
“Replication sort merge join processing

Explanation: