Articles & Content

Archives

Deep Dive into Query Performance Optimization: Zigzag Join , Jump Scan - H13

Topic: DB2 for LUW

Subtopic: 2012



DB2 10 has a number of features that significantly enhance data warehouse query performance. The DB2 team has implemented a very successful star join technique called the zigzag join that was used in Redbrick. Indexes are core performance objects in database systems. Attend this presentation to learn about this technique and what you need to do to exploit this technology. Do you have too many indexes on a table ? With a new jump-scan technique in DB2 10, you may be able to reduce the number of indexes you define on the table.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.