Articles & Content

Archives

D07 - Top Ten DB2 Explain Tips

Topic: DB2 for LUW

Subtopic: 2005



One of the most important factors in query performance is the access plan chosen by the DB2 for Linux, UNIX and Windows query optimizer. Understanding the query access plan is key to understanding query performance and the explain facility is the way to get the access plan. But SQL statements can be issued in different ways (dynamic, static, procedures, application programs) and access plans can exist in a variety of contexts (catalogs, dynamic statement cache, monitoring tables), so getting the correct access plan for the correct statement can sometimes be a challenge. This presentation will cover the most important tips for collecting and using explain information so that you can quickly and effectively understand your access plans in order to achieve and maintain the best possible query performance.



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.