Articles & Content
Archives
Performance Topics for DB2 Application Tuners (F08)
Topic: Cross Platform DB2 for z/OS & LUW
Subtopic: 2009
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
OBJECTIVES:
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?
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.