Stream: Nürburgring
Time: 14:15 - 15:00
While most application developers are familiar with basic joins, including cross, inner, and outer joins, less common types like lateral, anti, and self joins may be less familiar. In this presentation, we will explore the various join types in Db2, the phases of predicate evaluation during multi-table joins, and even how joins can be used to reveal masked data. We will cover both fundamental concepts and advanced techniques, along with useful tricks for effective join usage
There is currently no attachment for The Power of Joins in Db2: Elevating Application Performance with Advanced Techniques
Product Manager at Broadcom, part of the team shaping the strategy and roadmap for mainframe database and infrastructure tools (IMS & Db2). I focus on simplifying complex operations and enhancing the experience for enterprise customers running critical workloads on the mainframe.
Emil is a software architect at Broadcom Mainframe Software, he holds a Ph.D. in Mathematical Engineering, is a member of the IDUG Content Committee, and an IBM Champion since 2015.
Click here to give some Feedback so we can make it even better next year!