IBM
A2090-560 · Question #23
Click on 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?
The correct answer is A. Collocation hash join processing. See the full explanation below for the reasoning.
Question
Click on 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?
Exhibit
Options
- ACollocation hash join processing
- BDistributed hash join processing
- CBroadcast sort merge join processing
- DReplication sort merge join processing
How the community answered
(24 responses)- A83% (20)
- B4% (1)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.