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

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact