Articles & Content
Topic: 2007 EU
Subtopic: DB2 for LUW
DATE: 2007-11-8 (11:45 - 12:45)
SPEAKERS: Christian Schram (Compuware Austria)
The DB2 optimizer has two faces when dealing with access paths:sometimes a powerful one and sometimes a weak one, depending on whichinformation it is fed and how it is forced to make the correct choices.The most effective way to deal with this is to design appropriateindexes for SQL statements. This presentation discusses common mistakesin table and index design and discusses algorithms on how to designperfect indexes. As it is not always possible to implement the perfectindex, this paper also deals with criteria on how to judge tradeoffs anddiscusses possible enhancements to existing indexes based on examplesfrom the "real world".
EXP. LEVEL: Beginner,Intermediate,Advanced
Improving DB2 Application Performance
Understanding the Role of Matching Columns
Approaches to Index Design
Understanding the DB2 Optimizer
Improving Access Paths
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.