Articles & Content

Archives

Don't flip out! How to stop your query access plans from flopping (D17)

Topic: 2011 EMEA

Subtopic: DB2 for LUW



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.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.