IDUG DB2 Tech Conference in Denver, Colorado, USA 2012
Denver Colorado Convention Center, Denver, Colorado
May 14-18, 2012

View Printable Version

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

Session Number: 318
Track: DB2 10 for Linux, Unix, Windows
Session Type: Podium Presentation
Primary Presenter: Calisto Zuzarte [IBM Toronto Lab]

Room 105 => Fri, May 18, 2012 (08:00 AM - 09:00 AM)

Audience experience level: Intermediate, Advanced
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Data Architects, Database Administrators
Technical areas this presentation will apply to: New Release (DB2 for LUW)
Objective 1: Recall existing Star Join techniques
Objective 2: Learn about the new zig-zag star join technology
Objective 3: Understand what is required to enable this star join technology
Objective 4: Understand how you might be able to reduce some indexes defined on your tables

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

For questions or concerns about your event registration, please contact