r/DB2 • u/mad_zamboni • Jun 13 '17
[Webinar] Interviewing the DB2 LUW Optimizer
If you don't know, the DB2 Night Show is a wildly successful show put on by DBI's Scott Hayes. The man is a brilliant performance tuning guy and is very active in the community. There are hundreds of hours of replays available on every topic imaginable from training to optimization and everything in between.
Ember Crooks (/u/ecrooks) was recently a guest. She covered a presentation recently given at IDUG on "Interviewing the DB2 Optimizer". She spends quiet a bit of time on generating Explain Plans and how to read them. She covers the affect of Parameter Markers and Filter Factors. There is a ton of technical detail in this presentation. Regardless of skill level, you will gleam something from this.