View Printable Version

    Improving Query performance in DB2 LUW Warehouses

    Session Number: 371
    Track: Educational Seminars
    Session Type: Podium Presentation
    Primary Presenter: Calisto Zuzarte [Manager, DB2 Query Compiler CE, STSM - IBM]
    Room(s)/
    Time(s):

    Bonaire 7&8 => Mon, Apr 29, 2013 (08:30 AM - 05:00 PM)

    Speaker Bio: Calisto Zuzarte holds the following position :
    Manager, DB2 Query Compiler CE, STSM,
    Centre For Advanced Studies (CAS) Research Staff Member

    Audience experience level: Beginner, Intermediate, Advanced
    Presentation Category: Managing Performance
    Presentation Platform: DB2 for Linux, UNIX, Windows
    Audiences this presentation will apply to: Data Architects, Database Administrators
    Technical areas this presentation will apply to: Database Performance (DB2 for LUW), New Release (DB2 for LUW)
    Objective 1: Discuss The DB2 optimizer (Query Rewrite and plan optimizer)
    Objective 2: New features in DB2 10 ( zzjoin, hsjn, complex queries, compression etc)
    Objective 3: - Physical Design (focus on partitioning)
    Objective 4: - Performance Problem Determination (steps that I take to look for problems)
    Objective 5: - Optimal Indexing (tuning using indexes)

    Abstract:  - The DB2 optimizer (Query Rewrite and plan optimizer)
    - New features in DB2 10 ( zzjoin, hsjn, complex queries, compression etc)
    - Physical Design (focus on partitioning)
    - Performance Problem Determination (steps that I take to look for problems)
    - Optimal Indexing (tuning using indexes)
    - Getting Cardinality estimation right (tuning with better statistics)
    - Configuration that affects plans (tuning configuration)
    - Constraints (tuning using constraints)
    - Result caching (tuning using MQTs)
    - Organizing data (tuning data layout)
    - Application query design (tuning by manually writing queries)
    - Workload performance (tuning using WLM)

    For questions or concerns about your event registration, please contact support@idug.org


    Copyright © 2014 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