Articles & Content


DB2/LUW Best Practices Series: Writing and Tuning Queries for Optimal Performance (D11)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-14 (02:45 PM - 03:45 PM)
SPEAKERS: John Hornibrook (IBM Toronto Lab)

Query performance is not a one-time consideration. It should be considered throughout the design, development, and production phases of the application development life cycle.SQL is a very flexible language, which means that there are many ways to get the same correct result. This flexibility also means that some queries are better than others in taking advantage of the DB2 data server optimizerís strengths.This presentation covers the best practices for writing and tuning queries to best leveragethe DB2 data server's strengths. It will provide guidance for writing efficient SQL statements aswell as configuring DB2 to ensure the optimizer is running at peak performance. It will alsoprovide tips on using the explain facility to monitor and react to access plan problems.

EXP. LEVEL: Intermediate


How to write efficient SQL statements

Database and optimizer configuration

Important catalog statistics

Tips for using the explain facility

Deeper insight into query optimization

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.