The Learning Optimizer: An Overview of IBM Db2 AI for z/OS
Project and Program:
Information Management,
Database
Tags:
Proceedings,
SHARE Phoenix 2019,
2019
Choosing the optimal access path for a query, and doing that in a few milliseconds or less, is no easy task. Even with the most sophisticated query optimizer on the market (IBM invented cost-based SQL optimization), Db2 for z/OS doesn't always choose the best-performing access path for a query. Why? Largely because Db2 has had to act without information - specific to YOUR environment - that is critically important with regard to effective access path selection. Up until now, that is. The brand-new IBM Db2 AI for z/OS is going to fundamentally change the access path selection story in a positive way. This session will provide an overview of what IBM Db2 AI for z/OS is, how it does what it does, and its potential to substantially improve query execution performance in diverse Db2 for z/OS environments.-Robert F. Catterall-IBM Corporation
Back to Proceedings File Library