FEEDBACK Tables and PROFILES – is it a dream?

20 Mar 2018

RUNSTATS has always been a challenge in terms of what Syntax to use, which Statistics you need to collect and how frequently to collect these statistics. The past couple of Db2 releases have introduced some interesting features which can assist you in several ways to both automate the whole process as well as to figure out which Statistics the Optimizer would like to see in order to give it the best opportunity to choose a better access path. This session will explain RUNSTATS Profiles and the two different FEEDBACK tables populated by the Optimizer which can help you decide which statistics to collect.

Languages :  Polski Session Category :  Kraków 2018 

By continuing to use the site, you agree to the use of cookies. więcej informacji

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.