Articles & Content

Archives

[A08] DB2 11 Query Performance Optimization: Statistics Profiles and Collection

Topic: 2013 EMEA

Subtopic: DB2 for z/OS



DB2 11 significantly improves query performance and database administration through enhancements to catalog
statistics and optimization profiles. Statistics collection have been improved in DB2 11 to make them easier to use and
maintain. Their capabilities have also been extended to collect statistics for complex expressions used in predicates.
Statistics can now be collected automatically by the DB2 z/OS, using the same approach as
tables and nicknames. Statistics are now easier to deploy using the Optim Query Workload Tuner Statistics collection
advisor. Finally, DB2 Statistics profiles have been extended to make them more powerful and easier to use.
SQL statement matching is now more flexible so that an optimization profile
can match many SQL statements with a similar structure. Statistics profiles can now be used to specify certain registry
variables, so that they can be applied more selectively. Attend this presentation to understand how these new features can
improve your query performance and make administering your DB2 system easier



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.