DB2 for LUW

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

Nov 30, 2016 02:59 PM

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.

Attachment(s)
pdf file
L09 - Sage Advice Part 3.pdf   9.04 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.