Details

Join operations - Explaining Merge,Hash and Loop

Luke Jian
60 minutes
Dev
Intermediate
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.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids