The Joy of Joins

Monday, 13 June, 2022 - 12:15 - 13:00
z/OS Track
Emil Kotrč
Most of the application developers are used to use joins - cross joins, inner and outer joins. All resonate well. However, what if we start speaking about lateral join, anti join, self join, does it still look familiar to you? What if we take a look at the predicate evaluation phases in relation to joins - before, during, and after; especially in case of multi-table joins. Did you know, that you can even use joins to unmask the masked data? Do you understand the difference between the join types available in Db2? These are some of the questions we will be addressing.
In this presentation we will go through the basics to more advanced topics on joins. We will also show some useful tricks with joins.
1. Objectives
1. A brief introduction to joins - inner vs outer
2. More advanced join techniques - anti join, self join, lateral join
3. Join methods - nested loop join, merge scan, hash join, hybrid join
4. Predicate evaluation phases - before, during, after join


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2023

VODICE -  12th - 15th June 2023