Articles & Content
Topic: 2009 EU
Subtopic: Cross Platform DB2 for z/OS & LUW
DATE: 2009-10-6 (15:45 - 16:45)
SPEAKERS: Sheryl Larsen (Sheryl M. Larsen, Inc.)
Luckily, tuning DB2 SQL is not needed as frequent as other RDBMSs. However, as SQL statements grow in length and/or complexity, minor flaws in cost-based optimization can surface. Come learn how and when to change the optimizerís mind in DB2 V8, DB2 9 and DB2 X. Topics like proper index design, when is extreme query re-write necessary, when is limited fetch not effective, and much more.
EXP. LEVEL: Intermediate,Advanced
Demonstrate when to change the DB2 Optimizerís Mind
Demonstrate how to change the DB2 Optimizerís Mind
Demonstrate how to design indexes for a Workload
Demonstrate when manual query re-write is necessary?
Demonstrate when Limited Fetch is not effective?
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.