Name: B9 | Db2: Explain EXPLAIN
Start: 2026-10-27T16:30:00-0400
End: 2026-10-27T17:30:00-0400

Tuesday October 27, 2026 4:30pm - 5:30pm EDT

Technical details to Db2 LUW usage and optimization of queries
There are many sessions about the EXPLAIN facility in Db2 LUW, but they all lack the concise statements to find the right SQL queries, set everything up, do the EXPLAIN and draw the right conclusions by examples and working statements to copy-and-paste.This is a back-to-basics session, enhanced with experiences from real situations and best practices.This session was presented at IDUG NA 2025 in Atlanta. It was in the Top10 of the user sessions. I will update the material to version 12.1 and preferrably include details regaring AI optimizer

Speakers

Roland Schock

Principal, tasdevil Consulting

Roland is installing, using and tuning Db2 on distributed since 1993 or Version 2.1 for OS/2. After working for 25+ years for ARS Computer und Consulting GmbH as a Db2 expert he is now an independent consultant.His expertise and engagement for the community allowed him to be IBM Champion... Read More →

Tuesday October 27, 2026 4:30pm - 5:30pm EDT
Magnificent 1

Track B, Technical Session

Audience All
Subject LUW
Area Back to Basics, Best Practices, User Stories, Working with SQL

IDUG NA 2026

Roland Schock

Get help with the event

IDUG NA 2026

Roland Schock

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Get help with the event