Articles & Content
Topic: DB2 for LUW
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
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.