IDUG EMEA 2024

The Db2 AI Query Optimizer builds, trains, and uses Deep Learning Neural Networks to provide advanced query optimization capabilities. Introducing deep learning safely onto production database management systems is a monumental task. Learn about the tremendous engineering challenges we confronted as we transitioned the Db2 ML Optimizer Tech Preview into a production-ready feature in v12. Some of the many challenges faced were how to deliver good machine learning model accuracy across a wide variety of use cases, how to minimize impact to existing workloads running on the database management system, and how to minimize machine learning model storage requirements. Knowing how the Db2 AI Query Optimizer was designed and how these engineering challenges were tackled will give you the confidence needed to try out this new feature on your own database systems.