Articles & Content

Archives

DB2 for LUW Best Practices: Writing and Tuning Queries for Optimal Performance (C10)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-11-10 (11:00 - 12:00)
SPEAKERS: John Hornibrook (IBM Canada)

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 leverage the DB2 data server's strengths. It will provide guidance for writing efficient SQL statements as well as configuring DB2 to ensure the optimizer is running at peak performance. It will also provide tips on using the explain facility to monitor and react to access plan problems.

EXP. LEVEL: Intermediate

OBJECTIVES:

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.