Join optimization

 

A join operation is a complex function that requires special attention in order to achieve good performance. This section describes how DB2 Universal Databaseā„¢ for iSeriesā„¢ 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.

 

Parent topic:

Processing queries: Overview