Articles & Content

Archives

Optimizing DB2 Applications Using Extended Explain Tables

Topic: 2012 AU

Subtopic: DB2 for z/OS



The plan table externalizes optimizer's access path choice, but does not include information leading to that decision. In this session, we'll focus on the information contained in a key extended explain table - the predicate table - and the insight it can provide into optimizer's decisions. Queries will be provided that can be used to mine the explain tables and catalog so that potential query performance issues can be proactively identified and resolved.



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.