Articles & Content

Archives

DB2 for z/OS: Making Friends with the Optimizer (D16)

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

OBJECTIVES:

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.