Differentiate between nested loop, hash loop and merge join.

Question Posted / brahmpal singh

1 Answers
1033 Views
I also Faced
E-Mail Answers

Differentiate between nested loop, hash loop and merge join...

Answer / Neeraj Kumar Kashyap

{"Nested Loop Join": [n "Performs a sequential scan over one table to match rows with another table.",n "Inefficient for large datasets due to multiple passes through the data."],n"Hash Loop Join": [n "Creates a hash table (hash map) of one input table, then scans the second input table and searches for matching values in the hash table.",n "Quicker than nested loop join for large datasets, but requires more memory."],n"Merge Join": [n "Sorts both input tables and merges them in sorted order.",n "Very efficient for large datasets when both inputs are already sorted."]

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

What is the main purpose of normalization?

1 Answers

does pl/sql support “overloading”? Explain

1 Answers

Define union all operator and union.

1 Answers

What is db dialect?