Differentiate nested loop, hash join and merge join.

Question Posted / rizwan ahmad

1 Answers
1136 Views
I also Faced
E-Mail Answers

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

Answer / Kum Anshu Gupta

[Nested Loop Join: This join type performs a full scan of one table for each row in another table. It is generally slower but simpler to implement than other join types.nHash Join: This join type creates a hash table from one input and scans the other input, looking up rows based on their hash value. Hash joins can be efficient when both inputs are small or when the data is already sorted by the join key.nMerge Join: This join type sorts both inputs by the join key, then merges them together in sorted order. Merge joins are efficient for large datasets when the join key is well-distributed and the sorting can be performed efficiently.]

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

3 Answers eBay,

What do you understand by the terms entity, entity type, and entity set in dbms?

1 Answers

What is drivermanager getconnection?

1 Answers

What are the four objects in a database?

1 Answers

How to change database dialect?

1 Answers

What is Partial Backup ?

2 Answers

Enlist some commands of ddl, dml, and dcl.