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
HR
EN
SL