Articles & Content

Archives

D05 - DB2 Battle: Statement Concentrator vs. Optimization Profile

Topic: 2015 EMEA

Subtopic: DB2 for LUW



The DB2 Statement Concentrator helps to cut down compilation costs for similar statements, turning literals into parameter markers. But what to do with range predicates for different ranges? During the presentation we will take a look at REOPTimization, optimization profiles, lots of access paths, and, eventually, at DB2 section actuals.

The presentation will be based on my series of blog entries http://blog.4loeser.net/2015/02/db2-battle-optimization-profile-vs.html



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.