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