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