Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

What is merge join in sql server

Home
Forums

What is merge join in sql server

9yAsked Mar 24, 2017, 4:54 AM1.5k

HI,

what is merge and hash join ?

if anyone know and use it then please share the knowledge.

when one should go for merge and hash join.

if possible discuss it with a good example the significance of merge and hash join.

also tell me how merge and hash join is different from normal join

thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Ranjeet Patra9y ago
Accepted answer
Please have a look at the below links:

http://www.madeiradata.com/loop-hash-and-merge-join-types/

http://www.sqlserverblogforum.com/2011/10/merge-join-vs-hash-join-vs-nested-loop-join/

http://www.sqlrelease.com/nested-loop-merge-and-hash-joins-in-sql-server