Articles & Content
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.