The DB2 for Linux, UNIX and Windows query optimizer is responsible for choosing optimal query access plans, however it can't do its job properly without vital information about your data and database objects. The RUNSTATS utility has been used for years by database administrators to collect these statistics and store them in the system catalog tables. However, statistics collection has significantly evolved since RUNSTATS was first introduced. DB2 has a rich set of statistics to help the optimizer understand complex relationships in your data and across your tables. Statistics can be collected automatically and even at query optimization time. This presentation will provide an overview of DB2 statistics and the options to collect them, to help you achieve optimal query performance, with minimal administration effort.
This presentation is from the IDUG EMEA 2016 Conference.
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, dashDB and the Big SQL feature of Big Insights. John also works closely with customers to help them maximize their benefits from IBM's relational DB technology products.