DB2 Optimization and Access Paths: Understanding The Basics [Part 2]

DB2 Optimization and Access Paths: Understanding The Basics Part II: Joins Join Methods In Part 1 of this series we discussed simple access paths when a single table is involved. But what about joins and more complicated SQL statements? The DB2 optimizer has at its disposal a series of techniques that can be used to join table data. When more…