View Printable Version

D09 - Sage Db2 Performance Advice Part 5: To Drop, or not to Drop, That is the Question!

Session Number: 5079
Track: Db2 for LUW - II
Session Type: Podium Presentation
Primary Presenter: Scott Hayes [DBI Software]
Time: May 02, 2018 (08:00 AM - 09:00 AM)
Room: Commonwealth D

Session Code: D09
Speaker Bio: Scott Hayes is an IBM DB2 Gold Consultant and IBM Champion, the curator and host of The DB2Night Show, a Db2 Performance blogger, a member of the IDUG Board of Directors, and a long-time IDUG groupie. IDUG Philadelphia 2018 marks the 30th North American IDUG Conference that Scott has attended.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Data Management, Data Warehousing and Business Intelligence, Implementing New DB2 Releases and Features, Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW)
Objective 1: Quick Review of Sage Advice Parts 1 through 4, with an emphasis on Part 3 - Predictive Index Impact Analysis
Objective 2: Important Sources for Index Information including the Catalog and Monitoring capabilities.
Objective 3: Determining Impacting Workloads
Objective 4: Determining Candidate Indexes for Dropping
Objective 5: Determining the likely impacts of dropping any given non-unique index in pursuit of answering the burning question- can this index be safely dropped?

Abstract:  The Sage Advice series has taught weight based performance analysis, advanced index benefit analysis, predictive index impact analysis, and complete database index redesign (which was a bit of an exercise in futility). Still, one common DBA challenge lingers as a burning question- can a non-unique index be safely dropped? Will Db2 performance improve, degrade, or remain unchanged? This session seeks to provide a methodology and enlightenment for practicing safe dropping of indexes.

For questions or concerns about your event registration, please contact