What optimizer thinks about your statistics – SYSSTATFEEDBACK

27 Sept 2017 09:30  -  10:30
IBM Wroclaw

DB2 optimizer relies on statistics about tables and indexes. In most cases, if optimizer could
exploit more complete and accurate statistics, queries would perform better.
While, DB2 users often only gather standard or default statistics. It’s a challenge for users to identify
what detailed statistics should be gathered for the specific queries. This is a main reason for sub-optimal
(unsatisfied) query performance.
Start from V11, DB2 optimizer provide recommendations for missing/conflicting statistics via a new catalog table.
With it, DB2 users can easily gather accurate and complete statistics for optimizer and result in better query performance.
Yet, this practical new enhancement has not been widely utilized by DB2 users.
In this session, we will explain how DB2 worked in V11/V12, demonstrate how to utilize and benefit from it.


Aby pobrać prezentację należy się zalogować.

Existing Users Log In
 Zapamiętaj mnie  

Languages :  Polski Session Category :  Wrocław 2017 

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.