Improve DB2 query performance in a business intelligence environment
Specialized query tuning methods for data warehousing and BI
From the developerWorks archives
Date archived: January 13, 2017 | First published: March 22, 2007
Running large queries efficiently is a top performance challenge in a business intelligence environment. Learn techniques for improving IBM® DB2® data server query performance in this environment. Walk through various methods, step-by-step, then experiment on your own system. Each method is applied to a single SQL statement, using the db2batch tool to measure performance.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.