IDUG EMEA 2026

Poorly written or optimized Db2 SQL queries can use huge amounts of CPU and render applications unusable causing business impact.
This session will cover the different types of access paths the Db2 Optimizes uses to return data for queries and discuss their merits and use cases. We will look at the data written by the DB2 optimizer in the EXPLAIN tables and how we can interpret the data using AI to determine if an SQL is going to be cheap or expensive to run.
The session will cover filter factors and the role of RUNSTATS on access path selection and cover how one can influence the access path.