Main Content

Join operations - Explaining Merge,Hash and Loop

A talk by Luke Jian

About the Talk

November 5, 2011 10:30 AM

Washington, DC

Washington, DC

In this session we’ll look in depth at the three main types of join operations (Nested Loops, Hash and Merge) in order to understand how query plans are computed. We will look at the performance of Hash and Merge joins in different scenarios and explain why they are sometimes associated with poor performing queries.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus