About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
ISPASS 2000
Conference paper
DB2 for OS/390 V5 vs. V6 outer join performance
Abstract
The outer join operation is one of the most frequently used operations in a relational database management system. It becomes even more important in data warehouse and business intelligence applications. The processing of outer join of very large relations is a very costly operation. Therefore, a lot of effort has been expended in the development and implementation of optimization techniques to improve the performance of outer join. In this paper, the outer join optimization techniques implemented in DB2 UDB for OS/390 V6 (further reference as DB2 V6) are described and the efficiency is measured in a real world workload.