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
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.