View Printable Version

    Matching Indexes to SQL

    Session Number: 375
    Track: Educational Seminars
    Session Type: Podium Presentation
    Primary Presenter: Bonnie Baker [Bonnie Baker Corp.]
    Room(s)/
    Time(s):

    Curacao 5&6 => Mon, Apr 29, 2013 (08:30 AM - 05:00 PM)

    Speaker Bio: Bonnie Baker is a consultant and educator specializing in applications performance issues on the DB2 z/OS platform. She is an IBM DB2 Gold Consultant, a five-time winner of the IDUG Overall Best Speaker award, an IBM Information Champion, and a member of the IDUG Speakers' Hall of Fame. She is best known for her series of seminars entitled "Things I Wish They'd Told Me 8 Years Ago" and the "Programmers Only" column in IBM Data Management Magazine.
    Audience experience level: Beginner, Intermediate, Advanced
    Presentation Category: Application Design, Implementing New DB2 Releases and Features
    Presentation Platform: DB2 for z/OS
    Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
    Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), New Release (DB2 for z/OS), SQL and XML Performance
    Objective 1: "Random" Indexes - how they work and when they are appropriate, Index Compression
    Objective 2: Indexes that were required in the past for good performance that are no longer needed today
    Objective 3: Unique indexes with "Include" columns - how and when to use them
    Objective 4: Bi-directional indexes and exactly how they are used for sort-avoidance
    Objective 5: designing indexes for SQL and validating that the design is good.

    Abstract:  Index design in DB2 for z/OS is a whole new game today. There have been so many changes in the last few releases that our index design techniques should be readdressed. This seminar will not only cover DPSIs, multiple PIs, and NPSIs, it will also cover new issues, such as
    SQL that demands a particular index in order to pass a syntax check
    "Random" Indexes - how they work and when they are appropriate
    Indexes that were required in the past for good performance that are no longer needed today
    Unique indexes with "Include" columns - how and when to use them
    Bi-directional indexes and exactly how they are used for sort-avoidance
    Unpadded indexes and why they may not improve performance or save disk space
    Index compression
    And most important - designing indexes for SQL and validating that the design is good.

    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