Articles & Content

Archives

D07 - Best Practices for Achieving Reliable Query Performance

Topic: 2014 EMEA

Subtopic: DB2 for LUW



Optimal query access plans are essential for good data server performance and it is the DB2 for Linux, UNIX and Windows query optimizer's job to choose the best access plan. However, occasionally queries that were performing well suddenly degrade, due to an unexpected access plan change. This presentation will cover a number of best practices to ensure that access plans don't unexpectedly change for the worse. All access plans can be made more stable with accurate DB statistics and proper DB configuration. The DB2 data server provides a feature to stabilize access plans for static SQL across binds and rebinds, which is particularly important for applications using SQL Procedural Language. When all else fails, optimization profiles can be used to force the desired access plan. This presentation will show you how to develop and implement a strategy to ensure your access plans are rock-solid.



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.