PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
“Collocation hash join processing

B.
“Distributed hash join processing

C.
“Broadcast sort merge join processing

D.
“Replication sort merge join processing

Explanation:


Leave a Reply