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: Complex query optimization + multi-core parallelism - H12

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

    Room 105 => Thu, May 17, 2012 (02:45 PM - 03:45 PM)

    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: Learn about Hash Join enhancements
    Objective 2: Learn about the new aggregation techniques
    Objective 3: Learn about some specific query patterns that will perform significantly better
    Objective 4: Learn about the new enhancements related to multi-core parallelism

    Abstract:  This presentation talks about DB2 10 features that give you significant Out-Of-The-Box data warehouse performance benefits compared to previous versions of DB2. Common operations such as Hash Join and Aggregation are significantly enhanced. Some specific common patterns of queries are also internally rewritten to help boost performance in some cases improved by orders of magnitude. Many other changes previously only available by setting some registry variable are now enhanced and opened up. Significant improvements have also been made in intra-query parallelism.

    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