Join optimization

A join operation is a complex function that requires special attention in order to achieve good performance. This section describes how Db2® for i implements join queries and how optimization choices are made by the query optimizer. It also describes design tips and techniques which help avoid or solve performance problems.