Further understand column group statistics in DB2

Leverage the extended use of multi-column statistics in DB2 9.5 to improve cardinality estimates

From the developerWorks archives

Samir Kapoor and Vincent Corvinelli

Date archived: January 11, 2017 | First published: September 04, 2008

With multi-column statistics in IBM® DB2® for Linux®, UNIX®, and Windows® (DB2), the optimizer can determine a better query access plan and improve query performance when there is correlation between multiple predicates. In this article, learn how to use multi-column statistics to take advantage of the enhancements to the optimizer in DB2 9.5 that extend their use to a broader range of predicates.

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=335477
ArticleTitle=Further understand column group statistics in DB2
publish-date=09042008