Zigzag join enablement for DB2 star schema queries

From the developerWorks archives

Lee Chu and Sudhir Singh

Date archived: January 13, 2017 | First published: March 21, 2013

IBM® DB2® 10.1 Linux®, UNIX®, and Windows® introduces a new join method called zigzag join. Zigzag join improves consistency in performance as well as reduces the execution time of queries in data warehouse or data mart environments with large volumes of potentially partitioned data, complex ad hoc queries, and where database design uses a star schema. This article provides insight into the eligibility criteria of selecting the zigzag plan, how the zigzag join method works, using a zigzag join with a gap in the fact table multi-column index, using the ZZJOIN operator, and using the index advisor for zigzag join.

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.

Zone=Information Management
ArticleTitle=Zigzag join enablement for DB2 star schema queries