Articles & Content

Archives

Query Optimization Fundamentals - All About Joins (C13)

Topic: 2011 NA

Subtopic: DB2 for LUW



DATE: 2011-5-6 (08:00 AM - 09:00 AM)
SPEAKERS: Calisto Zuzarte (IBM )

This is a back to basics presentation. It describes the architecture of the 3 basic join methods in DB2 namely, the Nested Loop Join, The Merge Scan Join and the Hash Join. How do these joins really work and when are they most likely to be used. This presentation also covers star joins, a specialized higher level methodology for suitable star schema queries. In addition, we look at optimization strategies with choosing how tables are joined. Join processing in a database partitioned feature (DPF) environment is another important aspect that is covered.The objective of this presentation is to familiarize you with how joins are handled in DB2 and better equip you with knowledge that may help you improve query performance

EXP. LEVEL: Beginner

OBJECTIVES:

Learn the basic join methods in DB2. How they work ? When are they used ?

Learn all about star joins and when this method can be exploited

Learn how joins are done in DPF (Database Partitioned Feature)

Learn about the DB2 optimizer's join strategies when planning joins

Learn how to spot potential join performance improvement.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.