Db2 Turbo Statistics – How to Accelerate Your Query Performance

Download PDF

Watch recording (logged in Tridex members only)

Session title: Db2 Turbo Statistics – How to Accelerate Your Query Performance

Session abstract: Catalog statistics are what fuel the Db2 optimizer, and its tank is always full because of automatic statistics collection. However there are some extra buttons on the dashboard that you can use to enable even better statistics to really boost your query performance.

Statistical views are an advanced form of statistics that allow the optimizer to see relationships across joins and to see the data distributions for expressions and even groups of expressions. Statistical views can be combined with column groups and distribution statistics to provide a high-octane boost to your queries with the added benefit of more stable and reliable query performance. Attend this presentation to learn how to use these more advanced forms of statistics to get top performance out of your Db2 system.

Speaker biography: John Hornibrook is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS) and Db2 Big SQL. John also works closely with customers to help them maximize their benefits from IBM’s relational DB technology products.