Articles & Content
Topic: 2010 EMEA
Subtopic: 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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.