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