IDUG NA 2025

Accurate catalog statistics are the lifeblood of the Db2 query optimizer. Db2 has had automatics statistics support since version 8.2 and real–time statistics were introduced in version 9.5. Automatic statistics collection is enabled by default for new databases and is the recommend best practice. So if you are still hesitant to use them, attend this session to gain a deeper understanding of how they work and why you can trust them to simplify your DB administration and improve overall query performance. In addition to providing details on the automatic statistics architecture, this presentation will provide details on ways to monitor and control automatic statistics collection so that it works well for any type of Db2 system.