Articles & Content

Archives

Sage Advice Part 3: Predictive Index Impact Analysis – Know Before you CREATE

Topic: 2016 AU

Subtopic: DB2 for LUW



Whenever a DBA has an index they want to create to solve a performance issue, there is often someone raising an objection “But will this new index cause the database/application any harm?” For those that desire to successfully create indexes with confidence, this session will present a new method for predictively measuring the impacts of any new indexes so that informed decisions can be fearlessly made. Sometimes, too, this analysis method will reveal that the positive performance impacts of one or more new indexes might be BETTER than expected! #Winning! Example commands and SQL will be provided.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.