Improve DB2 query performance in a business intelligence environment

Specialized query tuning methods for data warehousing and BI

From the developerWorks archives

Vincent Corvinelli and Samir Kapoor

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=203713
ArticleTitle=Improve DB2 query performance in a business intelligence environment
publish-date=03222007