Title :
DB2 for OS/390 V5 vs. V6 outer join performance
Author :
Weihrauch, Muryela
Author_Institution :
Santa Teresa Lab., IBM, San Jose, CA, USA
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
Keywords :
business data processing; data warehouses; query processing; relational databases; DB2 UDB for OS/390 V5; DB2 UDB for OS/390 V6; business intelligence; data warehouse; optimization techniques; outer join performance; relational database management system; Databases; Magnets; Merging; Null value; Usability;
Conference_Titel :
Performance Analysis of Systems and Software, 2000. ISPASS. 2000 IEEE International Symposium on
Conference_Location :
Austin, TX
Print_ISBN :
0-7803-6418-X
DOI :
10.1109/ISPASS.2000.842280
